Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Reg: Bar Graph for TopN and rest of the values

Received Response
1
Views
1
Comments
User_JZKI6
User_JZKI6 Rank 4 - Community Specialist
edited Aug 13, 2024 5:11PM in Oracle Analytics Forum

Hi Everyone,

As we have no. of sales in vertical axis and rank of the regions in horizontal axis we have to plot the Bar graph. There will be prompt for dynamically selecting the TopN ranks of regions, if we select Top10/15/20 in the prompt it as to show all top 10/15/20 ranks of the regions with respect to sales and at last remaining leftover data as to be shown as 1 bar/ bucket.

Can anyone suggest on this.

OBI Version we are using: 12.2.4.1.0

Thanks,

Tagged:

Answers

  • User_JZKI6
    User_JZKI6 Rank 4 - Community Specialist


    Graph should looks like as above in the prompt we will select top range and rest of the items should show like this.

    Using presentation variable we till selecting top N range we did, and for showing rest of the items can anyone suggest on this how to achieve.


    Thanks in Advance,