Main Ticket Category(low,medium,high), how to show in bar chart?

[jim_chan]

Hi guys,

Client wants me to create a bar chart which can see the percentage length(low,medium,high) and number of tickets in each of the rating.

1) how can I create in such a way my scale is 0-100% ?

2) I am using count(ticket number) , how can i convert it into percentage value , and also able to show number to tickets in each of the segment?

at the moment, i only have screenshot, I do not have any samples data. Hopefully someone out there have done similar stuffs before. PLS HELPPPP!

Rgds.

Jim

[Gysbert_Wassenaar]

Yes, this has been done before. You need two dimensions. The first is the ticket category I guess which has 10 values. I'll call it DimA for this example. The second is the dimension that has the values 'low','medium' and 'high'. The expression you need is =dual(count([ticket number]),count([ticket number])/count(total <DimA> [ticket number])). Enable the option Values on Data Points for the expression. Then you need set the Subtype of the chart to Stacked (on the Style tab). And on the Presentation tab enable the option Plot Values Inside Segments.

[jim_chan]

i have used

count(ticket_number)/count (total <  customer > ticket_number)

it works. and showed me 0-100% stacked bar chart