aggr function without selection

[#1]

Hi out there,

i got a problem where i can't find a solution for.

I tried to build a formula for a gauge chart with fixed min and max:

min(aggr(count(value), date))

This formula works perfect, if don't select a Day, Month or so. I want to get it fixed at the whole data (date's).
All my think's with {1} didn't worked out.

Maybe someone has an idea for me.

Thanks

Christoph

[marcel_olmo]

If you want it "static", which means if you select a day, month, etc..., you don't want the gauge chart to change. You have to put all the fields you don't want to change in a set analyisis like this example :

min(aggr( count({$<Year=,Month=,Day=>} [Asiento Importe]) ),date))

Hope it helps!!

[johnw · Accepted solution]

I believe this:

min({1}aggr(count({1}value),date))

Both min() and count() need to be told that you want the whole data set, I believe.

[#4]

Thanks,

this was the solution 😉