How to best define a broken call by considering a difference between two dates.

[#1]

Hello;

I am interested to understand how we need to setup this kind of analysis in QV.

We are looking to understand how many broken calls we have per equipment over a period of time.

A broken call means that the customer contacted us within the 5 days after the start of a previous intervention.

If there is more than 5 days between the start of two intervention the intervention is considered as a normal intervention and not a broken call.

This can be easily set up in Excel, but what about QV. How should we identify the calculation of the difference between the last intervention start date and the previous intervention start date.

Please find hereby an example in excel.

Thanks to all of you in advance.

Kristel

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[#3]

Many thanks this is really helpfull!