Extract Date Parts from Datetime
Introduction
Need to analyze your data by different time periods? Holistics supports Date Parts to extract specific date/time components from your timestamps.
This feature lets you group and analyze your data by:
- Day of Week (e.g., Monday, Tuesday)
- Month of Year (e.g., January, February)
- Quarter of Year (e.g., Q1, Q2)
- Day of Month (1-31)
- Hour of Day (0-23)
- ISO Week (W1-W53)
Supported functions
Here's what you can extract from a timestamp like 2021-06-10 14:19:15:
| Date Parts functions | Output |
|---|---|
| By Quarter of Year | Q2 2021 |
| By Month of Year | June |
| By ISO Week | W23 |
| By Days of Week | Thursday |
| By Days of Month | 10 |
| By Hour of Day | 14 |
Example of how you can slice total orders by month of the year in a pivot table.
