Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Make a Top 5 in Prompt or Graph Selection

Received Response
1
Views
3
Comments
Igor1188
Igor1188 Rank 3 - Community Apprentice
edited Aug 13, 2024 5:17PM in Oracle Analytics Cloud and Server

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!

Answers

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    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.

  • Igor1188
    Igor1188 Rank 3 - Community Apprentice

    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
    Jerry Casey Rank 6 - Analytics Lead

    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)