Pareto Charts in Dashboards

BFuller · 02/25/22

Hello, I have several data sets I'm adding to a Dashboard and need to pareto the results in the charts. The data is entered by traveling employees and the results can change daily. I am new to Dashboards and learning as I go. I searched the community and didn't find a direct formula. Does one exist?

Jeff Reisman · 02/25/22

@BFuller

So you're looking for it to automatically sort highest to lowest and be presented in a bar graph on your dashboard?

If so, the easiest way to do that is with a report. Create a new report, select the sheet or sheets with your data, select the columns you want to see, set filter criteria, and set the sort:

On your dashboard, add a chart widget, select your report, and voila! There it is. Set your dashboard to refresh every minute, then when data changes your charts will update within a minute or two.

I then added Andrew at the bottom of my sheet, refreshed the dashboard and the chart put him in the correct spot:

BFuller · 03/04/22

Thank you so much!!! This worked!

Jeff Reisman · 03/04/22

https://community.smartsheet.com/discussion/comment/321526#Comment_321526

Glad it helped. If you could mark my answer as Accepted, I would appreciate it!

Adilson Mota · 06/28/23

Hello

About pareto I have a problem because I need to use two parameters.

Defect in the production and month I have problem

Pareto Charts in Dashboards

Answers

Help Article Resources

Categories