This content has been marked as final. Show 3 replies
I have a field : Call_Priority.
It holds the following values
I am trying to make a Straight Table diaplay the percentage of each of these values compared to the total.
The Dimention is Call_Priority.
Each field has a unique ID (fieldname ID)
I tried this expression:
But this is producing 100% for all Call_Priorities. This isnt right.
I think this is because it has Call_Priority as a dimention so the sum(ID) is calculating how many IDs are falling under each value (which will be the same as the count)
I need an expression which will give me the percentage of the total selection that falls within each of the <=7.... etc values
The % values should always add up to 100%.
Any advice is appreciated.