Loading

How to Get the Date When Running Sum Exceed a Threshold

Publiceringsdatum: Mar 31, 2025
Uppgift

How to get the date on which running total exceeds a threshold.
 

Steg
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.
 
Knowledge-artikelnummer

001456722

Bilagor

Example.twbx

40 KB

Example.mp4

1038 KB

 
Laddar
Salesforce Help | Article