How to create a card that includes top 3 rows (based on top 3 values)?

svetlana
svetlana Member
in Charting

I an trying to create a card that shows the top 3 reasons for termination based on the number of responses for each reason; I would also need it to show all other reasons when you drill down.

The dataset has 2 columns: Reason for termination (10+ reasons), number of responses.

Thank you in advance!

Tagged:

Best Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can use a table card and sort on the number of responses ands then in the analyzer settings under filter you can set the number of rows to return to 3.

    Doing a drill path to get all of the reasons will be difficult as Domo automatically filters your drill card based on what was selected

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • ST_-Superman-_
    ST_-Superman-_ Coach
    Answer ✓

    Hi @svetlana

    You could always use a Pie or Donut Chart. Just in the General Chart Properties enter 3 as the maximum slices:

    Snag_34326d.png
    Snag_34adf6.png

    You can even get more details on the "Other" category by just moving your mouse over that pie piece:

    Snag_35a3a0.png



    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can use a table card and sort on the number of responses ands then in the analyzer settings under filter you can set the number of rows to return to 3.

    Doing a drill path to get all of the reasons will be difficult as Domo automatically filters your drill card based on what was selected

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • svetlana
    svetlana Member

    Thank you @GrantSmith! It doesn't look like I have the option to return 3 rows in the filter section though, maybe it's somewhere else?

  • ST_-Superman-_
    ST_-Superman-_ Coach
    Answer ✓

    Hi @svetlana

    You could always use a Pie or Donut Chart. Just in the General Chart Properties enter 3 as the maximum slices:

    Snag_34326d.png
    Snag_34adf6.png

    You can even get more details on the "Other" category by just moving your mouse over that pie piece:

    Snag_35a3a0.png



    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • svetlana
    svetlana Member

    @ST_-Superman-_ Thank you so much for including the screen shots, it's a great idea and gets the job done :)

  • ST_-Superman-_
    ST_-Superman-_ Coach

    Using a table card per @GrantSmith you can do something like this:

    Snag_3a1591.png

    In this case, I added a Pareto to the drill path, but there is one extra step required in order to view all of the categories. You need to first drill into a single reason,

    Snag_3af041.png

    And then click on the "x" to remove the filter:

    Snag_3b496d.png

    Conversely, you could just have the top three table card displayed above this pareto in a dashboard layout:

    Snag_4151ec.png



    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman

Categories