Average leadtime between two max date

guillaume_gorli — Sun, 03 Oct 2021 09:18:00 GMT

Hello everyone,

I am working with a database listing ID Ticket, Category of ticket, Working Date and Closing Date as below :

Thus, i have several working Date for the same ticket and one sole closing Date for each ticket.

What i am trying to do is determine a leadtime between last working Date and Closing Date. i Managed to get the leadtime per ticket properly :

but now i need to produce a less detailed KPI showing average leadtime per category of ticket and per month but i cannot make it works.

This should look like this :

Attached is qvw and excel database for those who could help.

Thanks in advance

Guillaume

topic Average leadtime between two max date in QlikView