Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to add dynamic column name from data in table in OAC

Accepted answer
396
Views
13
Comments

I have date-related data and a requirement for a table with columns like city, month1, month2, and so forth. These month column names should dynamically reflect the data, adjusting automatically if there are changes in the date filter.

Is there a feature that can handle this requirement?

Welcome!

It looks like you're new here. Sign in or register to get started.

Best Answer

  • Hi @User_TUWA3 ,

    The number of columns in a visualisation/analysis is static, you can't change it dynamically.

    I'd transform your data unpivoting the month columns, in order to have only 2 columns: month name and month value. Then you can use a Pivot visualisation to achieve your goal.

«1

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.