In this Note, we'll show you how you can create a chart to show the Cumulative Sum (Running Total) with 'Window Calculation' feature.
We'll use this Unicorn (private startups that are valued more than $1billion) data. (Download link).
In this data, each row represents each unicorn company, and the columns are companies' attribute information.
The goal is to create a bar chart that shows the cummulative number of unicorn companies by Date and by Country.
First, create a bar chart by selecting the followings.
Now, it's time for 'Window Calculation'!
Click the 'Menu' icon next to the Y-Axis, select 'Quick Window Calc.', then select 'Cumulative Sum'.
And that's it, now you have a bar chart that shows the cummulative sum of unicorn companies by Date (Month) and by Country!
You can click on the Green Text to open the configuration dialog for more detail setting if you like.