1. User’s Guide for Oracle Analytics Desktop
  2. Enrich and Transform Data
  3. Adjust the Display Format of a Date or Number Column

Adjust the Display Format of a Date or Number Column

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

Tutorial icon LiveLabs Sprint

For example, you might want to change the format of a transaction date column from November 1, 2017 to 2017-11-01.
  1. On the Home page, hover over a dataset that you own, click Actions, and then select Open.
    If the dataset contains a single table, you'll see the transform editor. If the dataset contains multiple tables, you'll see the Join Diagram. In the Join Diagram, right-click a data source and click Open to display the transform editor.
    Description of data-preparation-toggle-options.png follows
    Description of the illustration data-preparation-toggle-options.png

  2. Click the numer or date that you'd like to edit, then in the Data Panel, click Number Format (for number columns) or Date/Time Format (for date columns).
    The Data panel displays a configuration pane for the selected column.
    Description of workbook-change-date-format.png follows
    Description of the illustration workbook-change-date-format.png

  3. In the Data Panel, click Auto next to Format and select an alternative format.
  4. Click Save Dataset.