How to use one global filter for all cards from different data table

[Anonymous]

Hi,

I have 4 cards made from data from 4 different data tables. I was wondering if there is a way to make 1 global filter that controls all 3 cards on a specific date range(what the filter is)

My attempt:

I tried connecting tables together by the dates in many to many relationship, but only 2 cards have data(digital alert and another one), the other 2 tables are null for some reasons. Please advise some help, thank you.

[SamWiseOwl · Accepted solution]

Hi @Anonymous 
Have you tried creating a calendar table like this: 
https://www.wiseowl.co.uk/blog/s2947/calendarauto-table.htm
Although use Calendar("01/01/2020", "31/12/2025") instead of CalendarAuto which has an issue at the moment, tweak dates to match.

Then join this onto the different tables and use it to apply the filters.