7 Replies Latest reply: Sep 4, 2018 5:27 PM by Wanyun Yang RSS

    Multiple time lapses

    Wanyun Yang

      I'm not able to show company data so I made up a similar scenario: I'm trying to calculate the time lapse between Question Status and Answer Status. And the problem is, what should the expression be if there are multiple Question-Answer pairs, which leads to multiple time lapses?

       

      For example, in below scenario, there should be two time lapses: 00:03 (from Id 336 and 339) and 00:04 (from Id 346 and 347).

      w.PNG

       

      Thank you in advance!