Forum Discussion
Help with Hourly Data Model
Does your hourly data have a date stamp as well as time? If so, you can extract just the date and use that field for your relationship.
With that said, I'm not sure I understand what you are trying to do? You want to be able to see hourly granularity when you filter by date?
I tried your suggestion about extracting just the date to use as a relationship field - didn't work . The date field is not unique in both data and summary table.
I am am looking to have access to hourly granularity for charts or for example average value by hour aggregated across several days
In the query editor, make a reference table that points at your hour stamp column.
Extract date.
Remove the time column.
Remove dups of date column.
Use this table to connect both your date field of your data table and the aggregated table.
In other words, this referenced table will sit between the two tables you wish to create a relationship between.
- Isn't that similar to the calendar table ?
Your problem is that your relationships dont have crossfiltering set to both directions.