Top 10 Display

If I am working a simple card bar chart and only want to show the Top 10 (or Top X) of the data set, how can that be done?  I look in Data Flow ETL and also card Beast Mode and don't see anything intuitive to accomplish this what I am guessing is a pretty standard query.    


  • At the bottom of the analyzer, you can designate how many rows you want to include - if the data set is structured to allow for this and sorted correctly, you can select the top 10 rows, for example.


    If aggregations are necessary or if more transformations are required, another approach could be to use a rank and window function in  Magic ETL - you can perform aggregations using a combination of Group By and/or Rank and Window tiles, rank on the values you are seeking to use and then on the card, you could filter on your rank field to include only rank values of 1-10.

  • DaniBoy



    If the reply, was helpful please click on "Accept as Solution".




    Dani aka "Mr.Dojo"

    Dojo Admin
    **Say "Thanks" by clicking the "heart" in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
    **You can update your Dojo Community name and avatar by clicking on your avatar then the "My Profile" button.
This discussion has been closed.