Rank Top 5 of the week

Options
Anna_Otake
Anna_Otake Member
in Charting

I am trying to solve 2 things and would really appreciate your help.

  1. When I take out the Sorting filter for SUM of Quantity and Fiscal Month with week (No Aggregation), the number of quantity changes, and the number of products per week also changes. This may be a data issue but is anything odd in this card?

Before:

image.png

After:

image.png

2. I am trying to only show the top 5 products per week and after doing some research, I am using this formula but this doesn't seem to be solving the issue. Any advice will be helpful!

RANK() OVER (PARTITION BY Fiscal Month with Week ORDER BY SUM(Quantity) DESC)

With the sorting filter:

image.png

Without the sorting filter:

image.png

Thank you!

Tagged:

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓
    Options

    Rank can be hard to do in a pivot table card. I would start with a mega table and see if you can get the ranking how you want it and then drag your ranking beast mode into the filter and set your number there. This video walks you through how to do it.

    https://youtu.be/0p2CP-r6C8Q

    **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.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓
    Options

    Rank can be hard to do in a pivot table card. I would start with a mega table and see if you can get the ranking how you want it and then drag your ranking beast mode into the filter and set your number there. This video walks you through how to do it.

    https://youtu.be/0p2CP-r6C8Q

    **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