Creating separate charts on a dashboard using the same report

Marcel Hovsepian

Hello,

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,

Marcel

Andrée Starå

Hi @Marcel Hovsepian

I’d recommend duplicating the report and updating the Report Builder and then using that for a second chart widget.

Make sense?

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Marcel Hovsepian

I’d recommend duplicating the report and updating the Report Builder and then using that for a second chart widget.

Make sense?

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Marcel Hovsepian

Thanks very much for the help Andrée. I was hoping to not have to do that but I haven't found a better solution yet.

Much appreciated.

Andrée Starå

@Marcel Hovsepian

You're more than welcome!