Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is there any specific requirements to exclude non working days or holiday?
Hi @Kushal_Chawda! Only working days.
Regards!