Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
I'm using the following expression ir order to count how many different aircraft are flying at the same time:
count({<DASI ={'$(vData3)'},NCIA={'GLO'},ONGR={'0'}>} DISTINCT KEYI)
Where,
- DASI is a Date Field (DD/MM/YY)
- NCIA is the airline
- ONGR is 0 or 1
- KEYI is a distinct ID for each aircraft
And my Dimension is Time (HH:MM):
Now, I would like to sum the available number of seats per time, using Time as dimension, but showint the sum of Seats per airline...
How can I do that?
try this
sum(aggr(count({<DASI ={'$(vData3)'},NCIA={'GLO'},ONGR={'0'}>} DISTINCT KEYI),KeYI))