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!