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

How can i sort objects in the prompt ?

Received Response
61
Views
3
Comments
John305
John305 Rank 5 - Community Champion
edited Aug 13, 2024 5:52PM in Oracle Analytics Forum

Hello ,

I want to sort the values in my prompt but without sorting the graphs in the same order  , Thank youu

pastedImage_0.png

Answers

  • ArijitC
    ArijitC Rank 6 - Analytics & AI Lead

    I guess you want to sort Jan to Dec ...so, instead of using all values use specific column values. Then select jan to Dec as sorted in the selected list. OBI will retain this order.

    pastedImage_1.png

    Thanks

    ArijitC

  • Gianni Ceresa
    Gianni Ceresa Mod

    That kind of thing need to be set in the RPD.

    For month columns with months names you set a sorting column to something which can be logically sorted (so 1 to 12 for months for example).

    If you set the "Sort order column" it will be sorted right everywhere: in prompts, charts etc.

    Capture.PNG

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    @John305 use Gianni's solution - it's the proper and correct way of doing things