Advanced Aggregation in List Box

prathipsrinivas — Sat, 16 Nov 2024 20:21:24 GMT

Hi Guys,

I am using Aggregation Expression like this

=Count(Aggr(If(count(GuestSKey)>2,1) ,Date,GuestName))

to find how many times in a single day , the Count(GuestSKey) is more than 2 for Guest name.

The thing is, now if I want to show these resultant in a list box, it is throwing error or it shows nothing.

It would be really helpful if anyone could point out what I am missing or where i am going wrong.

Thanks in Advance!

Prathip

Re: Advanced Aggregation in List Box

prathipsrinivas — Tue, 30 Jul 2019 09:48:33 GMT

Sorry Guys, Very Silly me.

Just had to one more aggr for Guest Name , That will do.

Something like this

=aggr(Count(Aggr(If(count(GuestSKey)>2,1) ,Date,GuestName)),GuestName)