How to Calculate Day Over Day Change

In this tip, I going to show you how to build 3 different KPI cards for measuring day over day change. In just a few steps, I’ll show you how to calculate:

1. Sales for the most recent day
2. Sales for the previous day
3. Difference in sales between those two dates
4. Percent difference in sales between those two dates

I'll then show you how to create these 3 different methods for displaying the KPIs so that you can create those that are most useful for your audience.

RESOURCES

• Data - https://data.world/vizwiz/sample-car-sales
• Month over Month Change - https://www.youtube.com/watch?v=ViD3vclgNv8
• Year over Year Change - https://www.youtube.com/watch?v=YuxYr4_l2ww