Forum Discussion
Help with Hourly Data Model
I too am not 100% sure of what your desired end result is, but if you go to the relationship view and double click on the relationship line, you can try setting the crossfilter direction to "both" and see if that solves your problem.
I'm happy to look at your sample file
I will try to explain my end result :
My summary table doesn't have hourly data. All my reports are based on the summary table, including slicers. However, whenever I have a need to report on hourly data on the same report, I cant. There is no direct connection from the summary table to the original. I have tried all your suggestions above - including creating a reference date table which sits between the two - Got an error message - hence my suggestion to table a look at my sample file to undersand my problem. I will appreciate any help I can get. Been at this for days.