topic Re: FirstSortedValue KPI in App Development

FirstSortedValue KPI

danimarc12 — Mon, 22 Nov 2021 10:07:10 GMT

Hi everyone!

I want to display a single KPI with a Count() function.

I have this chart

with this dimension

and this measure

I want to display a single KPI which count(distinct numpratica) of a single value (idstep=80) of the dimension in the chart.

How can I write this expression?

Thanks to all!

brunobertels — Mon, 22 Nov 2021 10:35:20 GMT

Try this

count(distinct {<idstep={'80'}> numpratica})

danimarc12 — Mon, 22 Nov 2021 10:36:45 GMT

Hi, it doesn't work because I must to keep only the last value, not all the values with idstep=80

brunobertels — Mon, 22 Nov 2021 10:50:18 GMT

try then

aggr(firsortedvalue( {<idstep={'80'}> NomeStep,- UltimaModifica), numpratica)

danimarc12 — Mon, 22 Nov 2021 11:01:49 GMT

Ok, I see the name of the field idstep=80

But I want to count it, I shoul see in this KPI the number 17