Charts Should Grow When New Pivot Values Added

Currently, if a new pivot value is added to a pivot table, the new value doesn't automatically pull in to a dashboard chart. You have to go and edit the dashboard chart to now pull in the new value.

It would be nice if you could point the dashboard chart to the pivot table as a whole, so that when that pivot table grows, the dashboard chart would adjust automatically to include the new value.

There is a workaround I've discovered, but it's manual and defeats the point of having the Pivot App.

Sign in to vote!

Find more posts tagged with

Idea Submitted

Pivot App

Comments

Genevieve P.

Hi @MariaCurtis

Thanks for posting your idea!

As an alternate solution, I would personally use a Report as the source for the chart. If you set the Report filter to grab all the rows that are "not blank", then as new rows are added into the source sheet, they will automatically appear in the Report (and therefore your chart!)

Cheers,
Genevieve

MariaCurtis

Hi Genevieve,

Thanks for the suggestion. But when we have multiple charts we want to build off of the same report, it's much faster to build a pivot from the report than it is to regroup and re-save the report as a new report, for the sole purpose of another chart on the dashboard. I like that with pivot I can reference the same report in many pivots, without having to change the report around.

Quick Links

Trending ideas

Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Sheet Icon Color Consistency
The 'Sheet' icon appears purple in the left navigation but blue within the sheet, creating inconsistency. Aligning icon colors across the platform would improve clarity and simplify user training. Please standardize the icon color to enhance user experience and reduce confusion during onboarding.