1 Reply Latest reply: Jun 22, 2018 10:00 AM by youssef belloum RSS

    Two date fields

    Wanyun Yang

      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!

        • Re: Two date fields
          youssef belloum

          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