1 2 3 Previous Next 41 Replies Latest reply on May 14, 2018 11:32 AM by Kelly McGrady

# Pie Chart with two Measures

Hello

I am trying to compare two measure in percentage but I am unable to do that, I need help to make it. bellow is my measure details

Hired Candidates (It is calculated filed with formula IIF([Employed] = 'yes',1,0)

Remaining Candidates (It is also a calculated field with formula SUM([Available]) - SUM([Hired Candidates])

Thanks

• ###### 1. Re: Pie Chart with two Measures

From my understanding you are trying to show hired and remaining candidates in one pie chart.

This should easily be possible.

But I think the way you are trying to achieve this is the wrong way.

Could you please share a sample data set - with dummy data if required - so myself or another community member can assist you with the best solution for your problem

1 of 1 people found this helpful
• ###### 2. Re: Pie Chart with two Measures

Hello Khalid

what is the possible way to share sample workbook with you.

Thanks

• ###### 4. Re: Pie Chart with two Measures

Thanks

• ###### 6. Re: Pie Chart with two Measures

Just to confirm

you want a pie chart that shows employed candidates against remaining candidates is that correct??

• ###### 8. Re: Pie Chart with two Measures

oh yes,, I am really looking for it. how you did that

• ###### 9. Re: Pie Chart with two Measures

hope this makes sense if you have any questions please let me know

1 of 1 people found this helpful
• ###### 10. Re: Pie Chart with two Measures

Hi Khalid

I have attached my sample workbook, could you please try pie chart on this data. I want to use only measure in the comparison. Hired Vs Remaining

Thanks

• ###### 11. Re: Pie Chart with two Measures

Hope this is what you need

• ###### 12. Re: Pie Chart with two Measures

Hope this is what you require

• ###### 13. Re: Pie Chart with two Measures

Hello Khalid

Thank you so much for your efforts, you know the total figure is 304 in which the actual hired is 266 and remaining is 38 so it means the percentage must be 87.5 and 12.5. Is there any other way to do it correctly.

Thanks

• ###### 14. Re: Pie Chart with two Measures

How do you get to those figures from your data

what are the filter options/ calculations that you are using

1 2 3 Previous Next