3 Replies Latest reply: Oct 18, 2018 1:27 PM by Robert Hutchings RSS

    Using Month as a Dimension on Multiple Date Fields

    Scott Allen

      Hello all,

       

      I am wondering if there is a way to make Month-Year as a free-standing dimension that I can use in timeline charts, where the dates are not connected to a Master Calendar.  I have multiple date values in different tables, and only a few are linked.  For example:

       

      StartOfCare Date and ReferralDate are in the same table.  Conversion Rate is StartOfCare/ReferralDate.  Referral dates and start dates can be in different months, especially at the beginning and ending of the month.

       

      I tried to make a month Dimension on an unlinked Master Calendar, but that didn't work .

       

      Any suggestions?  Thanks in advance for any feedback!