Top 10 items view

Options
RajNadar
RajNadar Member
in Beast Mode

we wanted to review top 10 item out of 1M items

i can apply for filter accordingly

example... how we should bring on ranking column while using beast mode

Capture.PNG
Capture.PNG


Comments

  • GrantSmith
    GrantSmith Coach
    Options

    You can utilize the RANK window function in a beast mode. Something like:

    RANK() over (PARTITION BY `List` ORDER BY SUM(`All Total`))


    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • RajNadar
    RajNadar Member
    Options

    @GrantSmith

    there is no column for 'All Total' column

    we should consider Grand Total (Column) how we should bring top 3 items only

  • RajNadar
    RajNadar Member
    Options

    example here you go...

    Capture1.PNG


  • RajNadar
    RajNadar Member
    Options


  • RajNadar
    RajNadar Member
    Options
    Capture1.PNG

    Region / Q1 / Q2 / Q3 / Q4 / Amount Total (column)

    Applied beast mode as below function but doesn't work for me.. not sure how to apply ranking 'Amount Total' side. (this column doesn't appear in datatable)

    RANK() OVER (PARTITION BY `Region` ORDER BY SUM(`Amount`) desc) <=10 then 'include' else 'exclude'


  • RajNadar
    RajNadar Member
    Options

    @GrantSmith

    the result give individual Gross grand total(column) level for each Qtr and add up ranking as Net grand total.. Not sure how we can decide the ranking as grand total level top 10 items.

    result should be 69,692 - rank 1

    25,980 - rank 2

    20,980 - rank 3

    20,314 - rank 4

    Capture.PNG
    Capture.PNG


Categories