I have created a few simple dashboards, but it appears that they only look at today's data. I need to use a date variable so that I can look at previous dates data.

I know that when I create the dashboard, I need to select the "CONTEXTUAL" option.

In Composer, I have created the Assisted Request with a "Date" variable, and when I run it standalone in Sentinel, I get prompted for a date. This allows me to look at previous days data.

The Assisted Request SQL looks like this, with Date being the variable:
WHERE EventDate='TrkParameter(Date ?,XFBTRANSFER,EventDate)'

When I run this Assisted Request in a Dashboard, there is no prompt for a Date.

My Dashboard has a variable tab, where I create the Date variable, and give it a name. I gave it the same name as the one used in the Assisted Request.

My DataSource Request has a parameter tab, and I also define the variable here.
TrkParameter(Date ?,XFBTRANSFER,EventDate)'

My Indicator Request also has this in the SQL
WHERE EventDate='TrkParameter(Date ?,XFBTRANSFER,EventDate)'

What am I missing? Why does my Dashboard not prompt for the variable?