Making my Y-axis in percentage.

[#1]

How do I make my Y-axis in a graph show in percentage, I have seen other post about this, but none is working for me. e.g I have 50 items and 40 meets my selected condition, The Line/Bar Graph should show 80% i.e out of 100%????

[sunny_talwar]

May be like this:

Sum(Measure)/Sum({1} Meaure)

[#3]

Hi Sunny, the result is this not as expected.

[sunny_talwar]

Would you be able to share a sample? Cause images don't really help...

[#5]

The measure TICKET_ID is over 70000 rows and they come in daily, I am trying to sort them out on a monthly, using the RESOLVE_TIME(month) as you see on the X-axis. Only I want is the TICKET_ID showing in percentage not number. what do u mean sample ?? like the below

TICKET_ID   MONTH       CONDITION- SLA MET     SLA Not MET 

70                 JAN                                     50               20

30                 FEB                                     25                5

60                 MAR                                    60                0

20                 APRIL                                  18                2

From that condition above, my Y-Axis should be by MONTH(X-Axis) the following;

60%     -JAN

80%     -FEB

100%   - MAR

89%     -APRIL.

will this help??

[sunny_talwar]

How do you calculate CONDITION- SLA MET and SLA Not MET? Is this an expression or field?

[#7]

Yes. There is an express. Below is the expression:

IF([TIER]='GOLD',

IF([DECODE_PRIORITY]='High' AND [Arrival to Resolve Days]<=1,'SLA MET',

IF([DECODE_PRIORITY]='Urgent' AND [Arrival to Resolve Days]<=1,'SLA MET',

if([DECODE_PRIORITY]='Medium' AND [Arrival to Resolve Days]<=3,'SLA MET',

IF([DECODE_PRIORITY]='Low' AND [Arrival to Resolve Days]<=10,'SLA MET','SLA Not Met')))),

IF([DECODE_PRIORITY]='High' AND [Arrival to Resolve Days]<=3,'SLA MET',

IF([DECODE_PRIORITY]='Urgent' AND [Arrival to Resolve Days]<=3,'SLA MET',

IF([DECODE_PRIORITY]='Medium' AND [Arrival to Resolve Days]<=10,'SLA MET',

IF([DECODE_PRIORITY]='Low' AND [Arrival to Resolve Days]<=20,'SLA MET','SLA Not Met')))))

Which works fine, with the two expected output.

[sunny_talwar]

I am not sure I am following completely... is there any way you can share your .qvf?

[#9]

The CONDITION - I created using a MASTER with the multiple IF condition in the function expression.

[#10]

And I cant find the option of saving as .QVf file???