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:

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi plehrman ,

Has your problem been solved? If yes, please consider accept it as the solutionto help the other members find it more quickly.

Best Regards,
Community Support Team _ kalyj