Forum Discussion

plehrman's avatar
plehrman
Frequent Visitor
4 years ago
Solved

Stacked Chart Including Multiple Columns from Smartsheet

Hi,   I have a Smartsheet with about 30 columns, all with drop-downs with the same selection values. I would like to create one stacked bar chart that includes counts for each selection in each col...
Need Help
  • MFelix's avatar
    MFelix
    4 years ago

    Hi  plehrman ,

     

    On the query Editor select the column name then do the following:

    • Transform
    • Unpivot Columns
    • Unpivot Other Columns

    The final result will be a table with 3 columns:

     

MFelix's avatar
MFelix
Super User
4 years ago

Hi plehrman ,

 

The best option is to unpivot the values in order to have it in a format that you can make the chart: