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.

Hi @User_TUWA3 , Do you know in advance how many month columns to display? Does it depend on the filters? e.g. when start date is 1st April and end date 26th May which month columns do you need to display? april 2024 and may 2024? or june 2024 as well?

Hi @User_TUWA3 , Do you need to automatically select different columns based on your filters, or only adjust column names? Are you using Classic Analytics or Data Visualization? I would use presentation variables (in Classic Analytitcs) or parameters (Data Visualization) to store the selected values in filters. Then create…

Hi @User_Y6C7L , Which connection type are using in the dataset? Does is it work as expected if you use a different connection type or an Excel file? If so, it could be a bug, and I would raise a SR.

Hi @User_Y6C7L , Are you trying to create the dataset from the workbook editor? If so, I would recommend to create the dataset using the Create button in the Home page, save it, and then add it to a workbook.

Hi @User_Y6C7L , From your screenshot, it looks like you are saving a workbook, not a dataset. Does the dataset appear in the Data page? Do you get any error message when saving the workbook?

@Jorge Olmeda Please share the link once created, I'd be happy to vote for it 😉

Hi @Jorge Olmeda , AFAIK this is not possible in Classic Analytics. You should be able to do it in Data Visualization, as it allows you to control each measure properties in separate way.

Hi @User_TUWA3 , AFAIK it's not possible to remove the List | Date Range | Relative Time options when the data type of the column is Date or Date Time. As an alternative, you can setup a filter on a string column that contains dates in YYYY-MM-DD format (but you will lose the calendar input if you do so).

HI @User_TUWA3 , You are using a calculated column to initialise the available values for the parameter, not as a default selection (Initial Value is blank, so nothing is selected by default). You should proceed as follows: Get the logical SQL generated by your calculation. You can add a table with your calculated column…

Hi @User_TUWA3 , Can you please share a screenshot of your filter definition and how you assigned your calculation to it? My understanding is that you are in a DV workbook. I would create a new parameter, initialise it with the first day of last month date, and then bind it to the start date in a date filter.

Hi @Aarvi-Oracle , You can find this information in the auditjson.log file located under DOMAIN_HOME/servers/obips1/logs

Hi @Erikaa-Oracle , TextBox visualisations support parameters. You can reference them with the following syntax: @parameter("parameter name")('default value') You have to define parameters in your target workbook, and eventually bind them to a filter or use a logical SQL to dynamically update their value.

Hi @Erikaa-Oracle , When you create the data action, you have to set Pass Values to Custom and make sure that the Description column is NOT selected.

Hi @Barbara Ba , I had the same error code (but with a different description years ago) and it turned out to be related to NULL values in the physical column. Does the same expression work if you apply to a column that does not contain any NULL value? I also suggest you to raise a SR. When .h and .cpp files are referenced…

Hi @User_534UY , I would replace the expression as follows: CASE WHEN IFNULL("Project"."Duration until MNR Start", -999) = -999 THEN 'NS' ELSE CAST("Project"."Duration until MNR Start" as CHAR) END Please let me know if it helps ;)

Hi @Ramprapanna Bhattacharya-Oracle , This post is almost 2 years old. I suggest you to open a new one, so you can properly manage comments and provide feedback about the correct answer.

Hi @Sowjanya Beeravolu , Does the code in your opaque view work if you run it as-is in SQL Server? Are you actually using any column from the opaque view in your analysis/workbook request? I would also suggest to set LOGLEVEL=2 and check the query log to have a better understanding of what is happening behind the scenes.

Hi @Erikaa-Oracle , This is the expected behaviour of dashboard filters in Data Visualization. Previously selected values in dashboard filters are persisted when you manually navigate between canvases, and they are not overwritten with actions if you don't specify a different value for them (either using a dedicated…

Hi @Saroj Kumar Behera , If you replace variable references with their actual values, are you able to connect and import metadata? From the screenshot, it looks like you are trying to import metadata from ADW. Did you implement all prerequisite steps listed in the documentation? Connect to Oracle Autonomous Data…