Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I currently have a chart that shows the count of notifications by territory and the overall avg notification count by territories. However, if I select 1 or 2 territories I only want to see their counts and the overall avg. I don't want the overall avg for the unselected territory. I want to see only one territory(count and overall territory avg) in my chart.
Thanks!
no selections
Territory | Count([Note#]) | Count ({<Territory=>} TOTAL [Notification #]) | Count ({<Territory=>} DISTINCT TOTAL Territory) | Overall Territory Avg |
720 | 720 | 12 | 60 | |
Z011 | 72 | 720 | 12 | 60 |
Z012 | 67 | 720 | 12 | 60 |
Z013 | 30 | 720 | 12 | 60 |
Z014 | 56 | 720 | 12 | 60 |
Z015 | 112 | 720 | 12 | 60 |
Z016 | 57 | 720 | 12 | 60 |
Z017 | 64 | 720 | 12 | 60 |
Z018 | 44 | 720 | 12 | 60 |
Z019 | 47 | 720 | 12 | 60 |
Z020 | 92 | 720 | 12 | 60 |
Z021 | 49 | 720 | 12 | 60 |
Z022 | 30 | 720 | 12 | 60 |
Currently if I select only Z014
Territory | Count([Note#]) | Count ({<Territory=>} TOTAL [Notification #]) | Count ({<Territory=>} DISTINCT TOTAL Territory) | Territory Avg |
0 | 720 | 12 | 60 | |
Z011 | 0 | 720 | 12 | 60 |
Z012 | 0 | 720 | 12 | 60 |
Z013 | 0 | 720 | 12 | 60 |
Z014 | 56 | 720 | 12 | 60 |
Z015 | 0 | 720 | 12 | 60 |
Z016 | 0 | 720 | 12 | 60 |
Z017 | 0 | 720 | 12 | 60 |
Z018 | 0 | 720 | 12 | 60 |
Z019 | 0 | 720 | 12 | 60 |
Z020 | 0 | 720 | 12 | 60 |
Z021 | 0 | 720 | 12 | 60 |
Z022 | 0 | 720 | 12 | 60 |
I would like it to be like this Z014
Territory | Count([Not#]) | Territory Avg | ||
720 | 12 | 60 | ||
Z014 | 56 | 720 | 12 | 60 |
Remove Territory= from all expression.
Could you post a small sample application? Seems to work in my attached sample (not using your data model, since I don't know it).
From any one expression like
Count ({<Territory=>} TOTAL [Notification #]) in place of this use
Count ( TOTAL [Notification #]) because by using Territory= it will bypass the field selection.
Interesting it works in your test app. At least I know I am on the write path. Not sure if I can post the sample app though.
Thanks!
It did not work. I used Territory = becuase I want to bypass the selection for the overall avg so it stays constant, regardless of which territory selection I pick.
Thanks for the help.
Just remove {<Territory=>} and TOTAL from your expressions.
{<Territory=>} ignores any selection in Territory field and TOTAL ignores chart dimensions. What I understand from your question, you don't need both of them.