Forum Discussion
Show data only for last week when multiple tables have data
Hi there! I have multiple data sources with dates and a value. I wish to have a report which displays data only for the last calendar (/ISO) week that all data sources have at least one value. ...
Hi amustafa - thanks for this!
The problem here is that I need to check that all the data tables contain data for at least one day of the week we're reporting on - if 'DataTable01' contains data for weeks 1-5, but 'DataTable02' contains data only for weeks 1-3, then the report needs to show data for week 3 only (as week 3 is the most recent week where data is present for both tables).
Using Relative Date will only provide the previous week/month etc. regardless of whether data tables contain data for for that week/month etc.
Any advice or guidance would be greatly appreciated.
Thanks!
Rich