Struggling with creating charts on a Smartsheet dashboard
I am really struggling with the steps I need to take to convert a smartsheet with incoming form data into charts that reflect that data. I've gotten as far as creating sheet summary fields using COUNTIF formulas, then creating a report from those, then creating a simple bar chart from the report, but I can't figure out how to translate this data into a stacked bar or line chart.
In Excel, I might create a chart to summarize the # of requests by request type, then stack the bar by the sales market from which the request was submitted. In Smartsheet, I can't figure out how to accomplish that summary. I can create a report that summarizes, but then the dashboard won't let me use a summarized report to build a chart.
Can anyone offer any recommendations?