Creating separate charts on a dashboard using the same report


Our team created a large sheet that collects data from Smartsheet forms that vendors complete. We then score those answers and send them to a Vendor Vetting report that only shows the scores and some basic additional info (fake data below). Is there a way I can create charts in a dashboard that only shows data based on the Identifier name?

For example a chart that shows data only for "Email Security" vendors. And then create a separate chart in that same dashboard that only shows the data for "Productivity" vendors? When I create the chart of the dashboard it forces me to choose all of the data from the Vendor Vetting Report for the chart and I don't see a way to filter the charts in the dashboard from the report.

Thanks for any help,



Best Answer