Fix Tableau Sales Growth Metric
Budget: ₹400 – ₹750 INR
I have a Tableau sales dashboard with four standard filters across the top and a “Time Unit” parameter that lets users toggle between Year, Qtr, and Mnth. When the parameter changes, a Time Period dropdown (values like Jan’25, Q1’25, Q4’25) appears so users can pick the exact comparison points.
The problem: the Sales Growth % calculation only behaves when a single hard-coded comparison is in place—Q4’25 vs Q3’25, for example. As soon as I extend the logic to cover the rest of the quarters or months, the metric goes blank or shows incorrect numbers. Because Time Period is stored as a string, I suspect the calc or the relationship between the parameter, filter, and date fields needs re-working.
What I need
• Diagnose why the current calculation fails once multiple Time Period values are involved
• Re-engineer the calculation (or the underlying date field) so Sales Growth % updates correctly for every combination of Time Unit and Time Period selected through the dropdown menu
• Return a working .twbx and a brief explanation of the fix so I can replicate it in similar dashboards
Tableau expertise with parameters, string-to-date handling, LODs, and quick filter interactions is essential. If you have solved a similar issue, I’d love to see your approach and have you apply it here.
The problem: the Sales Growth % calculation only behaves when a single hard-coded comparison is in place—Q4’25 vs Q3’25, for example. As soon as I extend the logic to cover the rest of the quarters or months, the metric goes blank or shows incorrect numbers. Because Time Period is stored as a string, I suspect the calc or the relationship between the parameter, filter, and date fields needs re-working.
What I need
• Diagnose why the current calculation fails once multiple Time Period values are involved
• Re-engineer the calculation (or the underlying date field) so Sales Growth % updates correctly for every combination of Time Unit and Time Period selected through the dropdown menu
• Return a working .twbx and a brief explanation of the fix so I can replicate it in similar dashboards
Tableau expertise with parameters, string-to-date handling, LODs, and quick filter interactions is essential. If you have solved a similar issue, I’d love to see your approach and have you apply it here.