Showing Only the Parent Rows in a Dashboard Chart

mitchell.taylor

Hi - I have created a dashboard to show pie charts of my data. My problem is that the pie chart wants to include every single row as a data point, I only want to show the parent rows and not the children. I used the formula "=Count(Ancestors(row))". This gives me a 0,1,or 2 based on how many ancestors the row has. But I'm having trouble making the charts do what I want. Any help? Pics below (I just want to show HR and F&A in the pie).

 

Andrée Starå

Hi Mitchell,

Are you referencing the main sheet? I'd recommend collecting what you need either in a so-called metric sheet or a report.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

I second Andree's suggestion. I would recommend a separate Metrics sheet that contains only the data you want displayed.

mitchell.taylor

Thanks both. I was able to figure that out with your help!

Andrée Starå

Excellent!

Happy to help!

Paul Newcome