Pie Graph challenge

Hi Team,

I am wanting to add to my pie graph the count of Reported, Escalated, Resolved, Parent Informed in column B. Can someone please help with the formula to use to group these Status' and to also group them as Labels.



Thank you!


  • Avatar
    Parker Selman Official comment

    Hi there,

    Thanks for the post! 

    Based on the screenshots provided, I would set column B as both your values and labels for your pie chart, with the labels grouped, and your values set to aggregate with the 'Count' method. You will also want to filter out 'Status' from your labels. After making these changes, you should see a value of 1 for Reported, Parent Informed, and Escalated, and 2 for Resolved. 

    I hope this helps! Please reach out to support@klipfolio.com if you have any further questions, 


  • 0
    Andy and Keely Birch

    Thanks Parker, this helped a lot :)

Please sign in to leave a comment.