Window Calculation with Chart & Data Wrangling

Window Calculation is a great tool to have when you want to visualize and analyze your data in a deep and effective way. It gives you a way to calculate numbers in a 'group' sensitive way.

For example, you want to accumulate the number of orders for each product or calculate average number of orders within a 7 days window for each country. Or, you might want to calculate your monthly sales growth rate compared to a year ago, a quater ago, etc.

These are the times when you want to use Window Calculations.

In this seminar, Kan will introduce the basic of Window Calculation along with some of the useful calculation types. He's also going to demonstrate how you can create such calculations directly inside Chart and also as Data Wrangling steps.

Agenda:

• What is Window Calculation
• Window Calculation inside Chart
• Cumulative Sum (Running Total)
• % Difference from First Date
• Moving Average
• Growth Rate Compared to A Year Ago
• Window Calculation as Data Wrangling Step

Past Seminars

You can check other past seminars on this page.

For the upcoming seminars, check out our Exploratory Online Seminar page!