Count of values in pie chart

[#1]

Hi

I have my data as below

Table

emp_id       status     Item

1              TRUE            1

2              FALSE          0

3              TRUE            1

4              TRUE            0

5              FALSE           1

6              Don’t know    1

7              Don’t know    0

8 

9 

10

I want the count in a single pie chart in  which

i want the count of emp_id  whose item =1 and status = True or False  (from above table count is 3)

i want the count of emp_id  whose item =1 and status = True or False or Don't know (from above table count is 4)

Thanks

[sunny_talwar]

Create a pie chart with no dimension and these two expressions

1) Count({<Item = {1}, status = {'TRUE', 'FALSE'}>}emp_id)

2) Count({<Item = {1}, status = {'TRUE', 'FALSE', 'Don''t know'}>}emp_id)

[kkkumar82]

I think even your second is also three

Sorry counting mistake

[#4]

Hi

Thank you so much but i cant drill down into the pie chart

[sunny_talwar]

You want to be able to select one or the other section of the pie? Is that the goal?

[sunny_talwar]

See if this is better

[#7]

Hi sunny yes when clicks on the second legend it should be drilled into a single pie

[#8]

if i ada a single dimension and a single expression then i am able to drill into pie chart

but with out dimension i cant be able to drill

[sunny_talwar · Accepted solution]

I did attach another qvw with the ability for the user to select one part of the pie, did you check it out?