Have line chart show previous week for every hour with type continuous

[Anonymous]

Hi,

I have two fact tables and basically doing a sum of one column minus sum of column from the other fact table. 

I need to show previous week numbers by every hour. 

I would like this line chart to not show value for every hour for every day last week on my x-axis.. 

I have a date table and a time table connected to both fact tables. But if I try to include both it i very long and won't fit into my report page. Does anyone have an idea on how to solve this?

I can't use my column from my fact table, since I'm using data from two fact tables.

Thanks!

[Anonymous · Accepted solution]

Solved this by adding a calculated table with the previous two weeks and each datapoint from my facttables. 

[Anonymous]

Could one option be to add a calculated table with previous weeks dates and and time of day for each of them? If so how could this be solved?