11 Replies Latest reply on Aug 6, 2016 3:06 AM by Disha Shah

    How do I calculate the average DateDiff across two data sources?

    jaimie.stark

      I need to calculate the average DateDiff where the two dates are in separate data sources. I've attached an example similar to what I'm trying to achieve.  In the attached example, I created 'Days from Process A to Process B' to calculate the DateDiff but am unable to calculate an average due to the inability to further Aggregate. Ideally the DateDiff (in days) would be calculated for each ID and an average of 'Days from Process A to Process B' would be displayed by Location.

       

      Any advice would be much appreciated! Thanks!