January 19, 2023
How to Calculate Day Over Day Change
aggregation
,
analysis
,
cards
,
change
,
day
,
day over day
,
how to calculate
,
KPI
,
latest
,
level of detail
,
LOD
,
percent change
,
previous
,
prior
,
tableau
,
tip
No comments
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:
- Sales for the most recent day
- Sales for the previous day
- Difference in sales between those two dates
- 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
Subscribe to:
Post Comments
(
Atom
)
No comments
Post a Comment