Im trying to use KPI Format as Start of MOVING_SUM.
MOVING_SUM(COUNT_TABLE("_CEL_SD_ACTIVITIES_CASES"), KPI("Number of process variants") *-1,0)
This KPI returns me an error: that start parameter should be an integer, which I firmly believe I am giving it integer. Using COUNT DISTINCT instead has not solved this situation btw.
This should show the same result as the formula below.
MOVING_SUM(COUNT_TABLE("_CEL_SD_ACTIVITIES_CASES"), -2,0)
Best
Fidy:
KPI(Number of process variants) *-1
Solved, when you use variant.
Hi joosbuijs,
-1 is actually correct usage, if you want to start accumulating the sum one number before, you may give -1 to the second variant.
I want to achieve in a line chart the gradual accumulation as the line goes to the right side, that is why I need to have SUM from negative numbers of starting point.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.