Forum Discussion
Summing Hourly Data from One Table with a Fixed Hour Block
You have provided a little too much detail. Can you please indicate which two tables you mean?
The two tables are linked by campaign name/campaign ID.Side note: you will want to do is to adjust your data model
Please identify which tables are facts and which are dimensions. Please do not use bidirectional search unless there is a dire need for it.
The two tables are the (BAM - Campaign Target Import) table and the (UI - Ad Group by Hour) table.
Is it possible to have a measure that returns a table of numbers between two numbers back?
Like From 0hr - 2hr returns [0,1,2].
With those numbers, I can sum the impressions across those hours (hour 0 + hour 1 + hour 2).
A new WeTransfer link has been created with the updated table names & relationships: https://we.tl/t-nD5ekyhbFG
Eventually, I would like for the (BAM - Ad Group Target Import) table to talk back with the (UI - Ad Group by Hour) table, but I expect the logic for the (BAM - Campaign Target Import) table can be used for the (BAM - Ad Group Target Import) table.
Feel free to delete/unlink the (Campaign Key), (Ad Group Key), and (Hour of Day Key) tables - those were made to help the BAM tables talk to the (Ad Group by Hour) table, but I'm open to a better way to have those table talk directly to each other.