Aggr set analysis

[Anonymous]

Hello Guys !

I want to make a expression, which need be fixed, even if i select a value. Here what i have:

FirstSortedValue (Distinct (Roteiro), -Aggr( count({1<evento={"Saida"}, Roteiro>}visitado) / count({1}Planejado) ,Roteiro))

So what i want is the first value. If i select something, it cant filter. I've tried to insert {1} in many places, but didnt worked.

How can we solve it?

Thanks !

[jerem1234 · Accepted solution]

Try putting it with firstsortedvalue like:

FirstSortedValue ({1}Distinct (Roteiro), -Aggr( count({1<evento={"Saida"}, Roteiro>}visitado) / count({1}Planejado) ,Roteiro))

Hope this helps!

[Anonymous]

Hello Jeremiah Kurpat,

It worked. Thanks a lot !

Morandi