Changing the Date Format in Your Chart

Intro

When you power up a chart in Analyzer using a column with date and/or time information, automatic time scale formatting is applied for most chart types. This means that Domo determines the most appropriate date grain and output format for your data. If there are periods with no data, gaps are shown accordingly in the timeline. All of the following chart types use automatic time scale formatting.

• Vertical bar

• Vertical stacked bar

• Line

• Symbol line

• Curved line

• Curved symbol line

• Multi-line

• Running total bar

• Running total line

• Vertical box plot

• Vertical grouped bar

• Grouped bar with line

• Stacked bar with line

• Grouped bar with symbol

• Stacked bar with symbol

• Running total grouped

For chart types not in this list, date and time information appears as it does in your DataSet. For example, if the dates in your date column use the format Month Day, Year, the dates in the chart also use that format. If there are periods with no data, gaps are not shown for those periods in the timeline. 

The following example shows a chart with automatic time scale formatting:

The next example shows the same chart with time scale formatting turned off:

Changing your chart's date format

You can change the date output format of a chart in the Chart Properties. You can change the date format in a chart only when automatic time scale formatting is not in use. So, for the charts in the above list, if you want to change the date format, you must first turn off automatic time scale formatting. You do this by checking Never Use Time Scale in Chart Properties > Category Scale.

To change the date output format,

1. In the Analyzer, click Chart Properties.

2. Click Category Scale.

3. (Conditional) If your chart is one of the types in the above list, turn off automatic time scale formatting by checking Never Use Time Scale.

4. In the Date Output Format field, specify the date output format you want.
   For example: MM.dd.yy or MM-yyyy

5. Click Apply.

Macros

When specifying a different format, you can use any of the following macros. 

Video - International Date Format

Changing the week display formatting

By default, when the date grain for a chart is set to Week, weeks are represented in the format "Week X," where X is the week number during the year. For example, the week of January 8th to the 14th would appear as "Week 2." However, in the Admin Settings, in Company Settings > Company Overview, you can change this formatting so that weeks are represented by dates instead of week numbers. So, for example, the week of January 8th to the 14th would be represented as "1-8" instead of "Week 2." Only users with an "Admin" default security role or a custom role with the "Manage All Company Settings" grant can do this. Note that this is a global setting that affects all charts in a Domo instance; it cannot be turned on for individual users.

if the company setting is to format weeks by week number, you will not be able to format weekly data differently. If they wish to format the date they would need to use the m/d/yyyy format for weeks in their company settings.

For more information about default security roles, see Default Security Role Reference. For information about custom roles, see Managing Custom Roles.

To change the week display formatting to show dates,

1. Click More in the toolbar at the top of the screen.

2. Select Admin in the menu.
   The Admin Settings page appears.

3. Select Company Settings > Overview.

4. In the Company Overview pane, select Week dates in the Week Display menu.

5. Click Save Changes.