Loading

How to Get the Date When Running Sum Exceed a Threshold

Дата публикации: Mar 31, 2025
Задача

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

Действия
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.
 
Номер статьи базы знаний

001456722

Вложения

Example.twbx

40 KB

Example.mp4

1038 KB

 
Загрузка
Salesforce Help | Article