Filter Top results in Sumo

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

Comments

  • kshah008
    kshah008 Contributor

    Hi all,


    Can anybody help @kingaaronj out?

    Thanks!

  • Gimli
    Gimli Contributor

    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:

     

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

Categories