FirstSortedValue KPI

[danimarc12]

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]

hi 

Try this 

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

[danimarc12]

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

[brunobertels]

hi 

try then 

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

[danimarc12]

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