Timing of data interactions on SQL queries.
I'm looking for clarity on how dashboard filters are linked on the backend when it comes to the SQL that's generated at runtime.
Scenario: a dashboard is created with two reports that both include a date filter. Report 1 has a user prompt date filter that is set to default to a dynamic date of current date-1. Report 2's date filter does not have a default value set.
On the dashboard, I set up a filter link using Report 1's date filter and link it to Report 2's date filter so both are filtered to the same dynamic date. When the dashboard is launched, does Report 2's query get sent to the db without the date filter at any point because the report does not have a default value, or does this query automatically include Report 1's default date value of yesterday when it is being loaded initially because they are linked?