Skip to main content
Question

MOVING_SUM using number of process variants

  • Dec 16, 2020 6:56 AM UTC
  • 3 replies
  • 138 views

Hi, thank you for dropping by this topic. 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

3 replies

  • Dec 16, 2020 12:55 PM UTC
Fidy: KPI(Number of process variants) *-1 Solved, when you use variant.

joos.buijs
Level 10
Forum|alt.badge.img+9
  • Level 10
  • Dec 24, 2020 2:15 PM UTC
Hi Fidy, Youre using -1 in your answer. Is this correct or should it be a positive 1?

  • Jan 18, 2021 10:33 PM UTC

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.