Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
The following chart shows me the number of aircraft flying per time, with the following expression and dimension:
//Expression
count({<NCIA={'$(vAirComp1)'}>} DISTINCT KEYI)
//Dimension
HHSI
But I have more than 1 day and more than 1 airline (NCIA), and if I don't select one specific date and/or airline (NCIA) the system will calculate all counts for that time, as you can see below:
My question is:
How can I show the average of counts? I mean, the average of aircraft flying at that itme.
Thank you guys!
I believe that you need to use the aggr() function, like this:
Avg(aggr(count(DISTINCT KEYI), HHSI))
I believe that you need to use the aggr() function, like this:
Avg(aggr(count(DISTINCT KEYI), HHSI))
Thanks Gary!