Showing Only the Parent Rows in a Dashboard Chart

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).

Find more posts tagged with

Formulas

Reports

Integrations

Community Platform

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

INDEX / MATCH / CONTAINS Assistance
Looking for your help, the below formula works for the moment: =IFERROR(INDEX({SFDC Opps for Renewals Range 1}, MATCH(SFOP@row , {SFDC Opps for Renewals Range 2}, 0)), "No Match Found") However the column above actually contains multiple SFOPs and so I think I need to add a CONTAIN element to the formula so when SFOP…
Writing Formula for Sheet Summary Field
Based on the screenshot below, I am trying to write a formula that will pull in the reason for change on the row where " most recent change" is checked. Thoughts on the best formula? I've tried: =IF([Most Recent Change]:[Most Recent Change] = 1, [Reason for Change]:[Reason for Change] , "") Is there something I can do with…
Issues with Attachments
Ok, I'm not new to Smartsheet but recently this simple automation has had me stumped. Pictured below is a simple automation we use to verify that an attachment has been added to each row in our system. IF attachment added or changed, THEN Change Cell Value. These worked beautifully all over our system until about a month…