How to select chart item

[#1]

Hi,

I have to show % of Failures by Type Vs Employee.

Could anyone help me which chart item suits this to show in graphiacal view as my user wants to see the % of Failures even though if it contains Zero values in Type and Employee

Thanks.

[#2]

Amelia

take the pie chart

Use Emp as Dim and Type as Expr and click the expression as relative.

Show all dim and values (presentation tab)

best regards

Chris

[#3]

Thanks

and I have to show % of Failures for Type and Employee by using below expression

Sum({<Result={'Fail'}>} distinct Reference)/Sum(Distinct(Reference))

when I am using Emp as Dim and Type as expr it is showing No Data to Display.

Please help me how to sort this.

[#4]

Amelia

would you mind to share your qvw?

chris

[#5]

Please find attched.

[#6]

Amelia

I don't understand the problem

I did some selections or no selection and i have always results

if you want to add % on the graph click in Presentation tab, Display values

chris

[#7]

Hi Amelia,

Please consider the attachment.

[#8]

Hi,

Thanks and just for clarity I haven't found anything different in attachment you mean is it correct?

[#9]

Hi,

Thanks and I would like to show % of Failures for both administrator and Type. Please help how can I set this.

[#10]

Hi,

Thanks and it is showing only Administrator but I need both Administrator and Type. Please help as I am not getting how to set this.