Filter Top results in Sumo


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.


  • kshah008
    kshah008 Contributor

    Hi all,

    Can anybody help @kingaaronj out?


  • Gimli
    Gimli 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:


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


    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"
  • kingaaronj

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

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

This discussion has been closed.