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…

Thanks @Gianni Ceresa and @Dan Vlamis, I checked and it was a database grant issue, which is now fixed. Regarding my second question on Approach 2, do you have any insights on what username and password are expected? Is it the DB username and password?

Yes, that would work for me. Thank you.

I am trying it in my OAC environment.

Thanks @Federico Venturin for the solution. Do you have any insights on how to create a form in OAC DV for users to fill out? This is something that I am trying to achieve with OAC landing page .

Sumanth V -Oracle, Is the screenshot you shared from a pivot table visual? Do you know how to prevent one of the columns from being highlighted? We only have three columns, and highlighting two columns doesn't look good. Any thoughts on how to fix this?

Thanks, @Federico Venturin! Your approach worked, but the Pivot visualization is highlighting a column that I want to avoid. Is there a way to prevent this column from being highlighted? Alternatively, if it's not possible to adjust the subtotal, can I move the grand total to the top in the table visualization?

@Federico Venturin ,If I can't make it dynamic, I'm considering using the city names from the data as static column names in the table. Could you assist me in creating those column names?

@Federico Venturin , Yes it will be depended on the filter. For example, in the scenario you described, the columns should only display April 2024 and May 2024, which are selected in the filter.

@Federico Venturin , Can you assist me in figuring out how to create a calculation that dynamically sets the column name? The approach I tried only added months to rows and didn't change the column names. Thanks, Rashmi

@BalagurunathanBagavathy-Oracle , I tried your approach but it adds the values to the row and does not change the column name.

@Federico Venturin, I want to show the month columns automatically based on the filter, let's say filter start date was 1st april and end date 26th June, then the table visual should show column name as below city| april 2024 | may 2024 | june 2024 I am using Data Visualization

Thanks for the query @BalagurunathanBagavathy-Oracle

Thanks @Federico Venturin approach suggested by you worked.

@Federico Venturin This is how my calculation looks like And this is how my parameter looks Binding this parameter to the filter shows no value in the field.I want it to set and display the last months first date.