topic Re: Get Last Sorted Value of Difference Modifier as KPI in App Development

Get Last Sorted Value of Difference Modifier as KPI

TinaHensel — Fri, 17 Sep 2021 08:04:07 GMT

Hello together,

I am struggling on the following issue. Lets say I have a dimension month and measure counter being a difference modifier including rangesum with:

RangeSum ( Above((　 count(distinct USER_ID) - Above((count(distinct USER_ID)))) , 0, RowNo()))

This lead s to the following result:

Now I ust want the value "-5" being displayed in a KPI chart. How is this possible?

Thank you very much!

Best regards

Tina

Re: Get Last Sorted Value of Difference Modifier as KPI

rubenmarin — Sat, 18 Sep 2021 08:28:33 GMT

Hi, if -5 is the difference since the first month to the last you can do:

Count({<monat={$(=Max(monat))}>}distinct USER_ID)-Count({<monat={$(=Min(monat))}>}distinct USER_ID)

Re: Get Last Sorted Value of Difference Modifier as KPI

Kushal_Chawda — Sat, 18 Sep 2021 12:55:29 GMT

@TinaHensel If your expression really gives you difference between current and first Month of the time then you can simplify your expression as below instead of using complex rangesum and above logic

=Count(distinct USER_ID)- Count(total {<monat={"$(=min(monat))"}>} distinct USER_ID)