Count?

[aaditya2000]

Hello:

I need help with calculation.

I want to calculate total count of cars where BreakWorkDone YES or NO

Any help is greatly appreciated.

Thanks

Cars	BreakworkDone
Car1	YES
Car2	YES
Car3	YES
Car4	NO
Car5	NO
Car6	NO
Car7	YES
Car8	YES

[Phil_Seamark]

HI @aaditya2000

Do you want a visual that will show that you have 5 yes and 3 No?

Or something that will say you have 8 cars? 

[aaditya2000]

Hello Phil:

Thank you for your reply.

it should show me that total 5 cars are YES and 3 Cars is NO.

I want to display this count of cars with Yes & NO in PIE chart.

Thank you again.

[Phil_Seamark · Accepted solution]

Hi @aaditya2000

If you drag the [cars] field to the canvas and turn it into a pie chart.  Make sure that [Cars] is in the value field, then drag [BreakworkDone] to the legend field as per this image

[aaditya2000]

Thank you phil, that helped me to resolve.

Thank you again.