6 Replies Latest reply: Feb 8, 2018 12:47 AM by Shahzad Ahsan RSS

    Cumulative line chart with year month and Employee wise

    Shahzad Ahsan

      Hi Friends

      I am using cumulative line chart. I have managed to calculate by year and Employee wise but I need month wise also.

      I am using drill down dimension for year month. Suppose if I click on any year then it should show month wise data.

      Please see the attachment.

       

      I am using this

       

      Dimension:

      1. Year_Month(Drill down)

      2. Employee Name

       

      Measure:

      Aggr(RangeSum(Above(Sum(if(SUBMIT_GRN_AMOUNT=0 and PO_TND='TND', GRN_AMOUNT)),0,RowNo())),EMPLOYEE_NAME,yr_d)

       

      Script:

       

      [Logistics]:

      Load *, Year(DELIVER_DATE) as yr_d,Month(DELIVER_DATE) as Month_d;

      SQL select * from REC_SUBMIT_KPI

       

       

       

      TempTable:

      LOAD Distinct yr_d

      Resident Logistics;

       

       

      Left Join (TempTable)

      LOAD Distinct EMPLOYEE_NAME

      Resident Logistics;

       

       

      Concatenate (Logistics)

      LOAD *

      Resident TempTable;

       

       

      DROP Table TempTable;