Skip to main content
Question

MOVING_SUM using number of process variants

  • December 16, 2020
  • 3 replies
  • 3 views
T
Level 4
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

T
Level 4
  • tomoki.tsune
  • Author
  • Level 4
  • December 16, 2020
Fidy: KPI(Number of process variants) *-1 Solved, when you use variant.
joos.buijs
Level 10
Forum|alt.badge.img+2
  • joos.buijs
  • Level 10
  • December 24, 2020
Hi Fidy, Youre using -1 in your answer. Is this correct or should it be a positive 1?
T
Level 4
  • tomoki.tsune
  • Author
  • Level 4
  • January 18, 2021

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.

Community Code of ConductAccessibility statement