Pulling data from two sheets' Sheet Summary into a YOY chart in a dashboard

I've been collecting data on total completed projects for several product lines in the Sheet Summary panels for this year's and last year's project tracker sheets. I'd like to make a two-color bar chart widget, with each year in a different color, showing the change year over year for each product line in the number of completed projects.

I've pulled the data easily into a Sheet Summary report, but I can't figure out how to pull that data into a chart on my end-of-year dashboard.

Where is my logic flawed? There must be a simple solution for this?

Find more posts tagged with

Dashboards

Sheet Summary

Accepted answers

Genevieve P.

Hi @Deirdre Spencer

I agree with @Bassam.M Khalil , it may be easier to help with this if we could see a screen capture of your Sheet Summary Report so we can test and replicate what you're looking to do.

As long as you have Numerical Data in your Sheet Summary Report, you should be able to make it into a chart widget. For example, here is my Sheet Summary Report:

Screen Shot 2020-12-23 at 11.31.23 AM.png

Then when I select this Report in the Chart Widget you'll see that it highlights all of my data:

Screen Shot 2020-12-23 at 11.31.56 AM.png

From this I can then adjust the colours of the bars that represent each year, add on numbers to the chart, or change the chart-type:

Screen Shot 2020-12-23 at 11.33.10 AM.png

You may need to click the "Switch Rows/Columns" button if you're not seeing the correct Legend right away. Is this what you're looking to do?

Cheers!

Genevieve

All comments

Bassam Khalil

Hi @Deirdre Spencer

Hope you are fine, could you please share screenshot for your project tracker sheets ( Remove any sensitive date ) to help me to understand what you are trying to do, and i hope i can help you.

Genevieve P.

Hi @Deirdre Spencer

I agree with @Bassam.M Khalil , it may be easier to help with this if we could see a screen capture of your Sheet Summary Report so we can test and replicate what you're looking to do.

As long as you have Numerical Data in your Sheet Summary Report, you should be able to make it into a chart widget. For example, here is my Sheet Summary Report:

Then when I select this Report in the Chart Widget you'll see that it highlights all of my data:

From this I can then adjust the colours of the bars that represent each year, add on numbers to the chart, or change the chart-type:

You may need to click the "Switch Rows/Columns" button if you're not seeing the correct Legend right away. Is this what you're looking to do?

Cheers!

Genevieve

Deirdre Spencer

Thank you for your responses. Not sure what I was doing wrong, but I've figured it out.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.