Chart Dashboard Widget using Sheet Summary data fields

It would be great to be able to use the chart widget with data held at Sheet Summary level.

Appreciate that there are 2 ways around this :

Create a report and chart against that
Add "helper columns" to the sheet itself

However, I'd prefer to reduce the number of new reports I'm creating, and keep sheet complexity lower with no new columns. Can't we just chart directly against the sheet summary data?

Sign in to vote!

Find more posts tagged with

Dashboards

Sheet Summary

Idea Submitted

Comments

Anthony Reese

I've made it a habit to create "Summary Sheets" to allow for this. I find sometimes I need to arrange the data in a specific way that would clutter up the primary sheet. Having said that I would welcome the ability to pull data from the sheet summary to simplify the solution. Thanks for suggesting it.

Angie Hatfield

It would save time so we don't have to duplicate efforts. Creating a sheet summary and then having to do it outside of the sheet to show on a dashboard is a big time waster but unfortunately a necessary evil.

Please help with this!

Chris_C

I've already got the information I need in a sheet summary— it'd be great to not have to create a metrics sheet that does the same calculations just so I can put a chart on the dashboard

J McG

I second the suggestion to let users use Sheet Summary fields for charts

Quick Links

Trending ideas

Report Widget Capability - Drag & Drop to create Report Widget in Dashboard from Workspace Panel
Hi, I was creating new dashboard and thought it'll be so nice to have easy drag and drop Report widget capability from Workspace Panel since I always group set of reports under one folder (for ease of finding them what goes on the dashboard). I think this would be great time saver especially if you have similar name…
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…
Asset Sharing should default to View, not Edit
Since the license model has changed, the option to Share should default to VIEW, not EDIT. The View option allows less-experienced users to share that way by default, and share as Edit only when needed. This allows for less cleanup during true-up. This also prevents users from adding provisional licenses unknowingly.