Make a Top 5 in Prompt or Graph Selection

Question

Hi,

I want to create a graph

1. X-Axis - Months (Jan, Feb...)

2. Y-Axis - Profit

3. In Graph Prompt Or Dashboard Prompt I want to represent only top 5 Merchants (There are like a 230 Merchants) but I only want to represent to user only 5 and the user will choose which one of them he will see

I Will glad if someone can help with point (3) how to make it ?

Thanks!

Jerry Casey · Answer

1. I believe you need a separate query for top customers, since TOPN acts like a filter, you can't have both in the same query.

2. Instead of TOPN(Profit Amt, 5 by Month), your formula would look like TOPN(SUM(Profit Amt by Merchant,Month), 5 by Month)

Igor1188 · Answer

Thanks,

Two more questions

1. If I want to make instead of Represent Top 5 Merchants , to Represent Top 5  Customers (with the same logic: profit.. dates ) - I am thinking to use Column selector for this - do you have another idea ?

2.   Profit Amt is aggregated at the product level and not merchant level - so I see top 10 products and not merchants , any idea what should I change ?

Thanks!

Jerry Casey · Answer

You can use either the TOPN function or the RANK function to identify or isolate the top 5 performers.

A column would look something like TOPN(Profit Amt, 5 by Month).  This is assuming Profit Amt is aggregated at the merchant and month level.