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.
