Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
brunolelli87
Creator II
Creator II

Sum when ID is distinct

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?

 

1 Reply
Chanty4u
MVP
MVP

try this

 

sum(aggr(count({<DASI ={'$(vData3)'},NCIA={'GLO'},ONGR={'0'}>} DISTINCT KEYI),KeYI))