9 Replies Latest reply: Nov 14, 2017 12:41 PM by Quy Nguyen RSS

    Use Calendar as Dimension

    Mark Ritter

      Here is my challenge.

       

      I have employee data.  It contains the hire date and the termination date and employee-id.

       

      I want to create a table where the dimension is the actual calendar year-month and show the total number hired and also terminated in that calendar month in the same chart.

       

      I have a master calendar QVD that contains 2017-Jan, 2017-Feb, etc.

       

      The hire dates and termination dates also have a year-month component.

       

      This is probably not hard to do.  But I am apparently calendar challenged.