1 Reply Latest reply: Sep 24, 2018 3:17 PM by Abhinay Ranjan RSS

    regarding avg no. of days to a remediation date

    Abhinay Ranjan

      Hi All,

       

      I need to find avg no. of days to a remediation date,

      I have used as expression if(len(RemediationDate)>0, avg (aggr(min(BusinessDate)-CreateDate),ISU_ID),null())

      Dimension should be BusinessDate.

      I have used this expression ,I have to pick the first date of min(business Date)-CreateDate that should be aggregated with ISU_ID  and avg of this  ,remediation date on which first time assigned.

       

      Regards,

      Abhinay

        • Re: regarding avg no. of days to a remediation date
          Abhinay Ranjan

          abhinayranjan11 wrote:

           

          Hi All,

           

          I need to find avg no. of days to a remediation date,

          I have used as expression if(len(RemediationDate)>0, avg (aggr(min(BusinessDate)-CreateDate),ISU_ID),null())

          Dimension should be BusinessDate.

          I have used this expression ,I have to pick the first date of min(business Date)-CreateDate that should be aggregated with ISU_ID  and avg of this  ,remediation date on which first time assigned.

           

          Regards,

          Abhinay