Grouping by Values

cgT — Tue, 20 Jun 2023 10:10:15 GMT

Hi everyone,

I'm trying to create a break down of booking group sizes. I want to group each booking (BooRefNo) by the number of seats sold into it (SoldSeats). So I end up with, for example:

Group size Count

1 50

2 220

3 140

etc... (numbers are examples, of course) any bookings with more than 10 tickets will be listed as '10+'.

this is what I have so far in my expression:

=if(sum(SoldSeats)<= 10,
Count({<SoldSeats = {"$ (=Sum(SoldSeats))"} >} BooRefNo),
Count({<SoldSeats = {">10"}>} BooRefNo))

My dimension is as follows:

=if(sum(SoldSeats) <= 10, sum(SoldSeats), '10+')

However, I'm just returning a blank table...

Thanks in advance for your help!

Re: Grouping by Values

cgT — Wed, 21 Jun 2023 14:41:35 GMT

So an update on this... I have noticed that my (now updated) expression is not aggregating SoldSeats by BooRefNo, so this means that if, say, 2 seats are sold on a booking line within the entire booking and 3 are sold on another, then it lists them in both the '2 tickets' category and the '3 tickets' category. I want the expression to sum any SoldSeats where the BooRefNo's match. This is what I've tried:

=if(sum(SoldSeats) <= 10,
Count({<SoldSeats = {'$(=Aggr(Sum(SoldSeats), BooRefNo))'} >} BooRefNo),
Count({<SoldSeats = {'$(=Aggr(Sum(SoldSeats), BooRefNo))'}>} BooRefNo))

Please help!

Thank you

topic Re: Grouping by Values in App Development

Grouping by Values

Re: Grouping by Values