Showing Top N and "Others" in Table Chart

b_rad

Hi,

I have a table chart which shows "Product" and "Sales" in a table chart. I would like to show Top N Products based on Sales (descending) and group the rest of the Products as "Others".

Is this possible?

ArborRose

Sample data:

Product,Sales

Product A,1200

Product B,950

Product C,870

Product D,1500

Product E,400

Product F,200

Product G,1750

Product H,300

Product I,100

Product J,600

ETL:

Group By:

Rank:

Gives:

Then create beast mode as Product Group:

CASE WHEN `Top N` <= 5 THEN `Product` ELSE 'Others' END

ArborRose

Create an ETL and use the Rank and Window tile to rank products by sales. Or beast mode with something like

RANK() OVER (ORDER BY SUM(`Sales`) DESC)

Once you have a ran defined you can create a beast mode

CASE 

  WHEN {rank} < = 5 THEN `Product`

  ELSE 'Others'

END

ArborRose

Sample data:

Product,Sales

Product A,1200

Product B,950

Product C,870

Product D,1500

Product E,400

Product F,200

Product G,1750

Product H,300

Product I,100

Product J,600

ETL:

Group By:

Rank:

Gives:

Then create beast mode as Product Group:

CASE WHEN `Top N` <= 5 THEN `Product` ELSE 'Others' END

b_rad

@ArborRose Thank you for the answer. Really appreciate it. I was hoping to do something within the analyzer itself. Hopefully they add this feature.