Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have a field : Call_Priority.
It holds the following values
<=7
>7 <=14
>14 <=21
>21
Ongoing
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:
=count(Call)Priority/count(ID)
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.
Thank you
L
try count(ID)/count(total ID)
Try
=count(Call_Priority) / count(TOTAL Call_Priority)
and set the format in number tab to show percentage.
Both work perfectly, unfortunately only one correct answer allowed!
Thank you for your help guys.
Each day i seem to learn just a little more!
Regards
L