Extract Date Parts from Dates
In a time-series report, you may want to group data by different time intervals such as Day of Week, Day of Month, Month of Year, Hour of Day, etc. Our Date Parts feature helps you extract these specific types of dates from time dimensions so that you can slice your data under different time lenses.
Here's the supported Date Parts functions:
| Date Parts functions | Input | Output |
|---|---|---|
| By Quarter of Year. | 2021-06-10 14:19:15.000000 | Q2 2021 |
| By Month of Year. | 2021-06-10 14:19:15.000000 | June |
| By ISO Week. | 2021-06-10 14:19:15.000000 | W23 |
| By Days of Week. | 2021-06-10 14:19:15.000000 | Thursday |
| By Days of Month. | 2021-06-10 14:19:15.000000 | 10 |
| By Hour of Day. | 2021-06-10 14:19:15.000000 | 14 |
Here’s an example of how you can slice total orders by month of the year in a pivot table.
Where to find the Date Parts functions
When you have included a time dimension in your report, you can access the Date Parts functions by clicking on that dimension in the visualization setting.
