Repeat Columns on Charts

connorryan36
edited 12/09/19 in Smartsheet Basics

Hi,

When I try to use the graph function on the dashboard I am having repeat values in the columns. Is there any way to get the columns to combine and the figures to add? For example... in the picture I want only one column for A.

Capture.PNG

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You would need to create a new column within your metrics that would essentially sum all of the A data together and then reference that in your widget.

     

    Or are you looking more for a stacked bar chart where A is broken down into 3 colors but all in one bar, B is 3 colors in one bar, etc?

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • Hi Paul,

    I do have similar issue and I am looking for second case where I want stacked chart where A is broken down into 3 colors under one bar, is that possible likewise for B, C....?