Showing Only the Parent Rows in a Dashboard Chart

mitchell.taylor · 07/02/19

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å · 07/02/19

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 · 07/02/19

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

mitchell.taylor · 07/02/19

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

Andrée Starå · 07/02/19

Excellent!

Happy to help!

Paul Newcome · 07/02/19

Showing Only the Parent Rows in a Dashboard Chart

Comments

Help Article Resources

Categories