LOD #11 - How to Percent Difference Against Average in a Range

Published: 19 May 2024
on channel: sqlbelle
1,198
39

This video covers in depth the 11th use case from the Top 15 Level of Detail (LOD) Examples, based on the Tableau Whitepaper written by Bethany Lyons.

This use case focuses on comparing the average value over a specified date range to a particular value elsewhere in the chart.

Learn to create charts that show specific date ranges, allowing for dynamic comparisons of daily values across different time periods.

We will use different calculations, as well as LOD expressions, to calculate the percent difference.

Practical Application in Business Scenarios:

Financial Analysis:
Monitor stock performance over specific periods against single-day fluctuations to inform buying or selling decisions.

Sales Trends:
Compare average sales in promotional periods to regular days to gauge the effectiveness of marketing campaigns.

Inventory Management:
Assess average supply levels over time against specific high-demand days to better prepare for future demands.

Whitepaper:
https://www.tableau.com/blog/LOD-expr...


Watch video LOD #11 - How to Percent Difference Against Average in a Range online without registration, duration hours minute second in high quality. This video was added by user sqlbelle 19 May 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,198 once and liked it 39 people.