A Date dataset is a dataset in the logical data model(LDM) that represents
TIMESTAMP columns in your database. The Date dataset helps you manage time-based data and enables aggregation at the day, week, month, quarter, and year level.
When a relationship exists between a standard dataset and a Date dataset, the related foreign keys are mapped to the
You can share a Date dataset with multiple standard datasets and then slice the facts from those standard datasets by the dates from the Date dataset.
You can create multiple Date datasets and create relationships between these Date datasets and one standard dataset, for example:
- Date datasets:
- Standard dataset:
Ticketscontaining two foreign keys,
A Date dataset in the LDM is identified by the following visual object:
Granularity Levels in a Data Dataset
GoodData Cloud Native (GoodData.CN) supports only a subset of the granularity levels that GoodData.UI supports.
The Date datasets support the following categories of date/time granularity:
When used in the LDM, the Date dataset defines what levels of granularity can be used in your analytics and how the titles of the those levels should be presented.
|Chronological||Minute||Date and time with minute granularity (for example, |
|Chronological||Hour||Date and time with hour granularity (for example, |
|Chronological||Date||Date with day granularity (for example, |
|Chronological||Week/Year||Week and year (for example, |
|Chronological||Month/Year||Date with month granularity (for example, |
|Chronological||Quarter/Year||Date with quarter granularity (for example, |
|Chronological||Year||Date with year granularity (for example, |
|Periodical||Minute of Hour||Generic minute of the hour (|
|Periodical||Hour of Day||Generic hour of the day (|
|Periodical||Day of Week||Generic day of the week (|
|Periodical||Day of Month||Generic day of the month (|
|Periodical||Day of Year||Generic day of the year (|
|Periodical||Week of Year||Generic week (|
|Periodical||Month of Year||Generic month (|
|Periodical||Quarter of Year||Generic quarter (|