Average of a count expression

[brunolelli87]

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!

[GaryGiles · Accepted solution]

I believe that you need to use the aggr() function, like this:

Avg(aggr(count(DISTINCT KEYI), HHSI))

[brunolelli87]

Thanks Gary!