Custom variables for date filtering

[tommyl]

Hello,

I am trying to create a date filter with "Enrolment Start Date" and "Enrolment end dates".

I created two variables in load editor: 

let filterStart = '01.01.1900';
let filterEnd = Today();

And use these as a dimension in the filter panes ( as Start Filter and End Filter)

And wrote a set expression for the chart measure, like:

=Only({$<enrolmentDate>=Date(Date#([$(filterStart)],'DD.MM.YYYY','DD.MM.YYYY') , enrolmentDate<=Date(Date#([$(filterEnd)],'DD.MM.YYYY','DD.MM.YYYY')>}(Count(memberId)/Count(total{1}memberId)))

It shows nothing. Could you please help me?

Regards,

[Nishanthi]

What is the desired output from you ? Could  you please brief out

[tommyl]

Hi,

To add date filter to the dashboard for enrolment date. Range picker xtension didnt satisfy the need. 

Regards,