Hi!
I am having trouble getting results. I have the following table:
| ID | DATE_START | DATE_END |
| 3420983428 | 2020-06-30 17:05:36 | 2020-07-01 14:00:19 |
| 5483543043 | 2020-07-01 16:36:58 | 2020-07-03 13:48:54 |
| 9230919321 | 2020-06-03 11:14:45 | 2020-06-05 18:00:02 |
| 7543934900 | 2019-12-18 14:24:46 | 2019-12-23 17:29:49 |
| 4320932198 | 2019-07-22 16:53:17 | 2019-08-02 10:04:24 |
| 6945832412 | 2019-08-06 11:32:58 | 2019-08-21 14:12:23 |
| 1209192319 | 2020-06-12 19:26:27 | 2020-07-03 16:15:16 |
| 2829819285 | 2020-02-03 16:21:03 | 2020-03-05 11:46:06 |
| 8432990773 | 2019-05-15 00:07:01 | 2019-08-16 10:09:15 |
| 9439439441 | 2019-08-20 10:55:42 | - |
First I would need to get an expression that would give me the number of working days, hours, minutes and seconds between DATE_START and DATE_END. In case DATE_END is NULL (like the last record) it should take today's date.
Then, I must obtain the average working hours based on the filters that I have selected in my dashboard.
Please could any one help me?
Thank you very much!
Regards,
Martín
