topic Bypassing field (filter) is not working in aggr function in App Development

Bypassing field (filter) is not working in aggr function

aatish12345 — Fri, 15 Nov 2024 21:44:57 GMT

Hi All, I have a expression in below format

Aggr(

If(Aggr(NODISTINCT Max(date(SampleDateField)), country, state, city) = [SampleDateField]

,avg([SALES])), country, state, city,SampleDateField)
)

In above expression I want to bypass [EmployeeName] field, so that after selecting EmployeeName from filter the result of expression should not change., but it is getting difficult for me to achieve the same , as after adding that field in set analysis , the filter is still getting applied to the result. I have also used Only function but it is also not helping.

Please suggest any workaround

Aatish

Re: Bypassing field (filter) is not working in aggr function

Chanty4u — Wed, 31 May 2023 11:37:27 GMT

Try this s

Aggr(

If(

Aggr(NODISTINCT Max(date(SampleDateField)), country, state, city) = [SampleDateField],

Avg({$<EmployeeName=>} [SALES])

country, state, city, SampleDateField)

Re: Bypassing field (filter) is not working in aggr function

aatish12345 — Thu, 01 Jun 2023 09:28:05 GMT

Let me get back