Question
How to get the date on which running total exceeds a threshold.
Last Modified Date: 08 Jul 2022
Environment
- Tableau Desktop
Answer
1. Create a calculation field [RunningSum]RUNNING_SUM(SUM([Value]))
2. Create a calculation field [DateMeetGoalOn]
WINDOW_MIN(IF [RunningSum]>=100 THEN MIN([Date]) END)
3. Drag the [DateMeetGoalOn] to Rows shelf and set the calculation direction as below.
[DateMeetGoalOn] :
[Special Dimension] > check [Month,Day,Year of Date]
[RunningSum ]:
[Special Dimension] > check [Month,Day,Year of Date]
※Please find the attached video "Example.mp4 " and "Example.twbx" for more details.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials