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

Labels(data maker) for total values only

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

Hi,

If I have 3 measures and I want to represent only the total of them as a label (like in a picture) , how can I do it in obiee (analysis)

Answers

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

    Vague question, vague answer: Combine all three measures into one.

    Seriously though:

  • Igor1188
    Igor1188 Rank 3 - Community Apprentice

    Hi,

    I tried to make a total but its a graph and there is a vary color by attribute so I attached the photo :

    https://ibb.co/HYw4Gqf

    Appreciate if there is a not vague answer

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

    So you want to see the grand total value but still split it by "something". That won't work as you can have several "somethings" - like market segments. And then also several bars - like months. So the "grand total" becomes a theoretical concept.

    tl;dr you'd need to specify a precise case and then look at what's possible (reference line/point comes to mind) but it really depends on WHAT you want to analyze HOW.

  • Igor1188
    Igor1188 Rank 3 - Community Apprentice

    ok

    the X - AXIS Based on Dates

    and "Vary color by" based on Category

    In DV (OAC)

    There is a total for this

    https://ibb.co/09KX41D

    in OBIEE I want to do the same and I cant find how :

    https://ibb.co/QbVF3WC

    So , how you suggest to solve it ?

    Thanks!