Hi, I wish to find top 5 sales representative in large dataset.

Options
learnDomo
learnDomo Member
edited July 7 in Calculations & Variables (Beast Mode)
salesData.xlsx

A sample dataset attached with one sales rep with different metrics.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach

    If you are using the bar chart, you can use these chart properties to do it:

    Drag your metric field that is determining your "top" people into the Sorting field and sort by descending.

    Next, in the General Chart Properties:

    Set Sort on Totals and Descending

    Set Maximum Items to 5

    Select Hide Other Bard


    image.png


    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories