Skip to content

    • Charting

    Charting

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

    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:

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answers

    • 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!**
    • Domo Employee
      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


    Answers

    • 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!**
    • 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?

    • Domo Employee
      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


    • Member

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

    • Domo Employee

      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


    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories