Pareto smartsheet

The objective is to assemble a pareto indicating the highest value for the lowest value in the Smartsheet.

Which is the best route?

I see the attachment

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    edited 06/28/23

    Hi @Adilson Mota

    Charts in Smartsheet are currently configured in the order you have data placed in your sheet. This means if you move the order of your Rows in the source it will update in the Chart.

    What I would suggest doing here is base your chart off of a Report. That way you can Sort the Report by the values so it always appears in your Dashboard in a specific order. Does that make sense?

    Cheers,

    Genevieve

  • Adilson Mota
    Adilson Mota ✭✭✭✭

    Hello Geevieve

    thanks about your retorn.

    But ,I need to sort this line in order greater to minor, because when I sort the relatory it sorts only the one below it


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Adilson Mota

    Ah! Thanks for clarifying that you're already using a Report and that it's Grouped. In this instance, the Report will be sorted by the Grouping text values alphabetically. There currently isn't a way to order the Report so those grouped header rows show in a different order.

    What I would do in this instance is use a Sheet with Formulas to create your numbers (instead of a Summarized Report).

    =SUMIFS({Hours Column}, {Primary Column}, [Primary Column]@row)

    See: SUMIFS / Cross Sheet Formulas

    Then you can make a regular row Report without Grouping to automatically sort your rows.

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!