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?

  • 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....?