Skip to content

    • Archive

    Archive

    Filter Top results in Sumo

    Member
    in Archive

    Hi, is there a solution for dynamically filtering top results in a Sumo table?  Example - Top 10 items in terms of revenue.  I know how to do it in a regular table card, but was wondering if there were a way to do this in a Sumo table.

    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

    Comments

    • Contributor

      Hi all,


      Can anybody help @kingaaronj out?

      Thanks!

    • Domo Employee

      Hello @kingaaronj,

      Sadly there is not a way to do this in a Sumo card, without creating a new column. 

      We can use a dataflow and create a ranking column. Based off of this ranking we can use it as a filter in the sumo card. 

      For example this would be the query we would use in a MySQL dataflow:

       

      1. SELECT
        a.*
        ,@rank:= @rank + 1 AS `Rank`
        FROM your_dataset a
        ,(SELECT @rank:=0) b
        ORDER BY ___

      2016-09-26_1718.png


      Now that you have a rank column, you can use it as a filter in your Sumo card. 


      **Say “Thanks" by clicking the thumbs up in the post that helped you.
      **Please mark the post that solves your problem by clicking on "Accept as Solution"
    • Member

      Thank you @ilikenno.  I'll give this a shot.

    • Unknown
      Unknown

      @kingaaronj, did @ilikenno's reply help you out?

    This discussion has been closed.

    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