1 Reply Latest reply: Feb 3, 2017 2:54 AM by Vineeth Pujari RSS

    Average in Line Charts Issue

    Amit Saini

      Hi Folks,

      I'm having below line charts :

       

       

      Dimension: Month

       

      Expression:

       

      Supplier:

       

      =Avg({<Defect_Imediate_Action={'LeadTime'},Complaint_Type_Description={'Supplier'}>} num((if(IsNull(if(Finished_Date < 2958465, date(Finished_Date))),

       

      floor(Networkdays(date(%DATE_Key),(today()))),

       

      floor(

       

         (if(Finished_Date < 2958465, Networkdays(date(%DATE_Key),date(Finished_Date))))

       

        )

       

      ))))

       

       

      Kautex:

       

      =Avg({<Defect_Imediate_Action={'LeadTime'},Complaint_Type_Description={'Supplier'}>} num((if(IsNull(if(Closure_Date < 2958465, date(Closure_Date))),

       

      floor(Networkdays(date(%DATE_Key),(today()))),

       

      floor(

       

         (if(Closure_Date < 2958465, Networkdays(date(%DATE_Key),date(Closure_Date))))

       

        )

       

      ))))

       

       

       

      Issue: Now I have to create one more expression "Overall" which should be average of these 2 expressions.

      So I'm trying simple =sum(Column(1)+Column(2))/Count(Column(1)+Column(2)) ,but it's not showing any result.

       

      Please help me out , what could be the best expression to calculate average of "Supplier" and "kautex".


      Thanks,

      AS