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

Compare values for same parameter,attribute in OAC

Received Response
21
Views
2
Comments
Rashmi Jadhav-Oracle
Rashmi Jadhav-Oracle Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

I have three columns: parameter, attribute, and timestamp in dataset. If the parameter and attribute are the same but the values differ across timestamps, I want to create a table that shows this difference and highlights it.

The table should look like this:

parameter | attribute | timestamp1  | timestamp2

How can I achieve this in Oracle Analytics Cloud (OAC) ?

Answers

  • Rajakumar Burra
    Rajakumar Burra Rank 6 - Analytics Lead

    Two options.
    Create a column using calculations if timestamp1 = timestamp2 as yes else no.

    Use this value in Viz to highlight.

    In classic we can achieve using conditional formatting directly but OAC conditional formatting is not as good as Classic OBIEE.

  • Rashmi Jadhav-Oracle
    Rashmi Jadhav-Oracle Rank 4 - Community Specialist

    Hi Rajakumar,
    I’m trying to show the difference between two timestamps for the same parameter and attribute. In the dataset, each timestamp,parameter and attribute appears as a separate row, but in OAC, I want to display it in a single row — where the parameter and attribute are the same — and show the values for two different timestamps side by side in separate columns.
    I tried approach 1, but it didn’t work.