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

[vinieme12 · Accepted solution]

not sure,but try

RangeAvg(column(1),Column(2))