Adjust the Display Format of a Date or Number Column

You can adjust the display format and granularity level of a date column.

LiveLabs Sprint

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

1. 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:

   Oracle Analytics displays a Data Diagram for single-table datasets or a Join Diagram for multi-table datasets.
2. Hover over the column you'd like to edit.
3. Click
   
   

   
   Description of the illustration column-options-menu.png

   
   
4. 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.
5. 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).
6. Click Add Step.
   Oracle Analytics adds a step to the Preparation Script panel.
7. To save your data preparation changes and apply them to your data, click Save Dataset.