Custom date format allows you to set the desired format for the date field implicitly and apply formatting based on fiscal year. This can be supported for all date formats such as year, month, date, day, and many more.
NOTE: Custom date format support is only applicable for chart and grid widgets.
The custom date format option is applicable only for the date-time type of dimension column. To configure the custom date format settings, open the
Date Settings dialog from the
Settings option by clicking
Edit.. menu item,
Date Settings dialog will open as follows.
Date Settings dialog have following options that allows you to customize date field with the applicable date format:
To clear the custom date format settings for date field, click
clear in the settings drop-down menu. This menu item is enabled only when the date field is already configured with custom date settings.
Date field can be customized by
Fiscal year start options provided in
Date Settings dialog.
You can customize the date format of the date field using various custom date format options based on the fiscal year. For example, if the date format is
Year, then the year format can be customized by using the provided default options like
Follow these steps to apply predefined date format:
Choose any one of the predefined format option as follows.
The supported built-in date format types are provided in the following table.
|Year||2016, 2017, ...|
|Quarter||Quarter 1, Quarter 2|
|Q1, Q2, Q3, Q4|
|1, 2, 3, 4|
|Month||Jan, Feb, Mar|
|1, 2, 3...12|
|01, 02, 03...12|
|Hour||00, 01, 02, 03...|
|1 AM, 2 PM..|
|0, 1, 2, 3....|
|Minutes||00, 01, 02, 03...|
|0, 1, 2, 3...|
|Seconds||00, 01, 02, 03...|
|0, 1, 2, 3...|
|Quarter Year||Quarter 1 2017, Quarter 2 2018|
|Q1 2017, Q2 2017|
|Month Year||Jan 2016, Feb 2017|
|January 2016, February 2017|
|Date Hour||23/07/2017 00|
|Week of Year||00, 01, 02, 03...|
|Week 0, Week 1, Week 2...|
|Week 00, Week 01, Week 02...|
|Day||00, 01, 02, 03...31|
|1, 2, 3...31|
You can see the
Custom option under the
Format drop-down which allows the user to customize the date format based on the requirement.
For example, if the date format is
Date, then the format will be customized by MM/dd/yyyy, dd-MM-yyyy, and more.
Follow these steps to apply custom format:
A textbox will be enabled which is named as
Add desired formats which can be referred from supported format information while hovering over the
The preview of entered date format will be displayed under the text box.
NOTE: Custom Format is visible only for Date Time, Date, Year and Date Hour.
The supported custom format types are provided in the following table.
|Year||yy||Displays the year, from 00 to 99|
|yyyy||Display the year as a four-digit number|
|Month||MM||Display the month, from 01 through 12|
|MMM||Display the abbreviated name of the month|
|MMMM||Display the full name of the month|
|Hour||HH||Display the hour, using a 24-hour clock from 00 to 23|
|hh||Display the hour, using a 12-hour clock from 01 to 12|
|Minute||mm||Display the minute, from 00 through 59|
|Second||ss||Display the second, from 00 through 59|
|Time||ttt||Display the AM/PM|
If you want to apply the custom format along with the fiscal year, use the
Fiscal Year Start option from the
Date Settings dialog as follows.
NOTE: Filtering operation won’t work when you are choosing the widget as a master where you are applying the Custom date format for the date column.