Forum Discussion

aaditya2000's avatar
aaditya2000
Helper II
8 years ago
Solved

Count?

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...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    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

     

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

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's avatar
aaditya2000
Helper II
8 years ago

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's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    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's avatar
      aaditya2000
      Helper II
      8 years ago

      Thank you phil, that helped me to resolve.

       

      Thank you again.