Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My source data has a date field named VisitDate. I created a master calendar with a field Date. In the dashboard, I created a Date filter, and a table with Visitdate as a dimension. If I want VisitDate show only the dates within the Date filter range, how should I write the function for VisitDate dimension?
Thanks in advance!
Hi,
your master calendar should be linked to your fact table by the Date field (or key field which represent the date).
you can simply do this:
* Rename VisitDate to Date on your fact table
OR
*Rename Date to VisitDate on your MasterCalendar
Hi,
your master calendar should be linked to your fact table by the Date field (or key field which represent the date).
you can simply do this:
* Rename VisitDate to Date on your fact table
OR
*Rename Date to VisitDate on your MasterCalendar