topic Ignoring selections in AGGR in App Development

Ignoring selections in AGGR

mrmoster — Fri, 08 Oct 2021 14:09:15 GMT

I am trying to work out query to select the latest month one of our offices had a new starter. After a bit of effort I managed to get the below to work, but I cant work how to get it to ignore when the month is selected on a filter or chart.

Read similar posts but just cant seem to figure it out. Might be I have not worked out the best way to the find out the month. Any help would be much appreciated.

max({$<Month>}Aggr(if(sum({$<[Data Collection Requirement]={"New Starters"},[Month]>} [All Count])>0,Month),Month))

Re: Ignoring selections in AGGR

stevejoyce — Fri, 08 Oct 2021 14:36:39 GMT

This will fix your issue. remember you'll need to ignore month in all references.

max({$<Month>}Aggr(if(sum({$<[Data Collection Requirement]={"New Starters"},[Month]>} [All Count])>0, only({<Month>} Month)),Month))

Re: Ignoring selections in AGGR

mrmoster — Tue, 12 Oct 2021 09:16:14 GMT

Thanks for the fix, knew I was missing out filter somewhere!