2 Replies Latest reply: Oct 26, 2016 3:29 AM by Miguel del Valle RSS

    Measure on different Date against Generic Date in Chart

    Mohammad Sarif

      Hi All,

      I have Fact table called Request having Opened_Date, Opened_Month,Closed_Date and Closed_Month. Closed_Date/Moth and Open_Date/Month can be different.

      I need to create a line chart with two Metrics:

      Open_Count: Count({$<Opened_Month ={Last 24 Months}>} Req_number)

      Closed_Count: Count({$<Closed_Month={Last 24 Months}>} Req_number)

       

      But in X axis we need to have a generic Month that is Prior_Months. Which we have created using below script:

       

      Last_Month:

      Load

       

        Date(MonthStart(Today(),-RowNo()+1), 'YYYY-MMM') as Prior_Months

       

      AutoGenerate 26;

       

       

      Could you please help on this.

       

      Thanks,

      Sarif