Compare values for same parameter,attribute in OAC

Question

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) ?

Rashmi Jadhav-Oracle · Answer

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.

Rajakumar Burra · Answer

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.