
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aggr not working
Hi Eveyone,
I have 3 Expressions in my Chart (Nation%, Division% and Practice%),
Both Nation% and Practice% are working as intended but not the Division%
When i select a ProviderNBR the Division line should be the % in the selected providerNBR's Division.
But now it is as similar to Practice% and overlapping on the Practice%
Expression for Division:
= aggr(sum({< EMVisitTypeDSC={'NPV'}>}EMVisitCNT),CPT, DivisionNM)/
aggr(sum({<EMVisitTypeDSC={'NPV'}>}TOTAL EMVisitCNT), CPT , DivisionNM)
Please look at the attached test Application.
Thanks
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be try this
= aggr(sum({<MeasureNM={'E&M Visits'}, EMVisitTypeDSC={'NPV'}, ProviderNBR=, DivisionNM = p(DivisionNM)>}EMVisitCNT),CPT, DivisionNM)/
aggr(sum({<MeasureNM={'E&M Visits'}, EMVisitTypeDSC={'NPV'}, ProviderNBR=, DivisionNM = p(DivisionNM)>}TOTAL EMVisitCNT), CPT , DivisionNM)
Just an observation... you seem to have unnecessarily made your expressions/dimension complicated using Aggr... I am not entirely sure what you goal is to use Aggr(), but whatever you might be trying to do can be replicated using simpler expression and dimension...


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There is no attachment can you please re upload your file.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not sure if this works but just try below:
= Sum(aggr(sum({< EMVisitTypeDSC = {'NPV'} >} EMVisitCNT),CPT, DivisionNM))
/
sum(TOTAL <CPT, DivisionNM> {< EMVisitTypeDSC={'NPV'} >} EMVisitCNT)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nope this doesn't work.
I have attached the app to main question


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check attached?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That is a good one but since we have only one Division in my sample it worked fine.
But if we have more than one division and when we omit the Provider selection how will the expression know to filter to the particular division.
I have loaded one more division into it you will understand what am saying.
Select provider number 2 and see the Division% graph it will combined of both Urology and allergy.
then select Urology you will see difference in the line Division%


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry Nithin, i left by the time you sent this response. Will look into it and get back.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be try this
= aggr(sum({<MeasureNM={'E&M Visits'}, EMVisitTypeDSC={'NPV'}, ProviderNBR=, DivisionNM = p(DivisionNM)>}EMVisitCNT),CPT, DivisionNM)/
aggr(sum({<MeasureNM={'E&M Visits'}, EMVisitTypeDSC={'NPV'}, ProviderNBR=, DivisionNM = p(DivisionNM)>}TOTAL EMVisitCNT), CPT , DivisionNM)
Just an observation... you seem to have unnecessarily made your expressions/dimension complicated using Aggr... I am not entirely sure what you goal is to use Aggr(), but whatever you might be trying to do can be replicated using simpler expression and dimension...
