Adjusting the Display Format of a Date or Number Column

You can adjust the display format of a date or a time column by specifying the format and the level of granularity.

For example, you might want to change the format of a transaction date column from November 1, 2021 to 2021-11-01, or change the level of granularity from year to month.

On the Home page, open a dataset or workbook.
- Select the dataset, click the Actions Menu , and then select Open. In the Data Diagram or Join Diagram, right-click a data source and click Open to display the transform editor.
- Select the workbook that contains the dataset, click the Actions Menu , select Open, then click Data. In the Data Diagram or Join Diagram, right-click a data source and click Open to display the transform editor.
  Note:CIC Analytics displays a Data Diagram for single-table datasets or a Join Diagram for multi-table datasets. For file-based data sources, Oracle Analytics displays the transform editor directly.
Hover over the column you'd like to edit and click Options.
To change the format of a date column, click Convert to Date, then click Source Format and select the format you want to use in the visualization.
To change the format of a number column, click Edit, and use functions in the functions library to change the format.
For example, to round up a number column DISCOUNT_VALUE from two decimal places to no decimal places, specify ROUND(DISCOUNT_VALUE, 0).
Click Add Step.
CIC Analytics adds a step to the Preparation Script panel.
To save your data preparation changes and apply them to your data, click Save Dataset.
If you're working with a single table dataset or a file-based dataset, click Apply Script.

Related Topics