u/waddle777

What I want to try here is the following-

When the user clicks on a button with the event name, the dashboard filters to the start date and end date showing the data outcome that has happened during that particular time period.

eg: user clicks on Christmas holidays -> Dashboard reflects sales made that day and other key parameters.

How does one achieve this? We can't use table relationships for this.. Do we make a measure for this and apply as a filter, I've tried this but I'm still very lost, would appreciate for some guidance. Thank you.

Hi Everyone, I'm dealing with a bit of a situation here and would very much like some guidance.

I have two tables;

One contains the list of events (event name, start date, end date), whereas the other contains details of messages sent through (title, start date, end date etc).

What I want to try here is the following-

When the user clicks on a button with the event name, the dashboard filters to the start date and end date showing the data outcome that has happened during that particular time period.

eg: user clicks on Christmas holidays -> Dashboard reflects sales made that day and other key parameters.

How does one achieve this? We can't use table relationships for this.. Do we make a measure for this and apply as a filter, I've tried this but I'm still very lost, would appreciate for some guidance. Thank you.