Forum Discussion

reast's avatar
reast
Icon for Helper II rankHelper II
10 years ago

Filter Active Clients by Date Range

I'm trying to figure out how to use the time slicer to filter active clients. They don't have a single date field to link with the calendar. They have a start date and an end date (or it's blank if t...
Need Help
reast's avatar
reast
Icon for Helper II rankHelper II
10 years ago

But those calendars still link to the start and end dates? This is what I'm getting. We should have over 300 clients at any given time, but this is only counting those with that specific intake, not including prior intakes that are still open.

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
10 years ago
reast wrote:

But those calendars still link to the start and end dates?

No


the dates I am talking about come from the 2 new single column tables you need to create.  Do not connect them to any other table.  Just build the measures as suggested