topic honoring the dimension within nested aggregation in App Development

honoring the dimension within nested aggregation

Bolderaft — Sat, 05 Jul 2025 00:00:36 GMT

Been beating my head against the wall. What am I missing?

Trying to create a measure to count active records below the median:

=Count (if (InCareNow=1 and SpellDays<Median(Total SpellDays), SpellID))

The problem is that the nested aggregation is scoped over all records, but I want the median just for the group of records associated with the dimensional value. I want to remove the "Total" qualifier from the inner aggregation but this is not allowed. My tiny brain does not comprehend why.

I have tried using Aggr but ran into the same issue. Any help would be appreciated. Thank you!

Re: honoring the dimension within nested aggregation

Chanty4u — Sat, 05 Jul 2025 15:37:54 GMT

Try this

Count(

If(

InCareNow = 1 and SpellDays <

Aggr(Median(SpellDays), [Patient Group]),

SpellID

)

Re: honoring the dimension within nested aggregation

Bolderaft — Sat, 05 Jul 2025 19:58:53 GMT

Thanks, I tried this as well but this is not working. Not sure why!