1
FALSE
2019-05-30 16:46:39 +0000 UTC
2019-06-30 16:46:39 +0000 UTC
Open
1
TRUE
2019-05-30 18:46:39 +0000 UTC
2019-06-30 18:46:39 +0000 UTC
Open
1
TRUE
2019-05-30 18:46:55 +0000 UTC
2019-06-30 18:46:55 +0000 UTC
Open
2
FALSE
2019-05-30 16:46:13 +0000 UTC
2019-05-30 16:46:13 +0000 UTC
Resolved
2
TRUE
2019-05-30 16:52:32 +0000 UTC
2019-05-30 16:52:32 +0000 UTC
Resolved
2
TRUE
2019-05-30 16:52:40 +0000 UTC
2019-05-30 16:52:40 +0000 UTC
Resolved
3
FALSE
2019-06-06 19:14:27 +0000 UTC
2019-06-06 19:14:27 +0000 UTC
Open
4
FALSE
2019-06-06 19:22:40 +0000 UTC
2019-06-06 19:22:40 +0000 UTC
Open
5
FALSE
2019-06-05 21:27:42 +0000 UTC
2019-06-05 21:27:42 +0000 UTC
Resolved
5
TRUE
2019-06-06 18:10:51 +0000 UTC
2019-06-06 18:10:51 +0000 UTC
Resolved
6
FALSE
2019-06-05 21:47:29 +0000 UTC
2019-06-05 21:47:29 +0000 UTC
Resolved
6
TRUE
2019-06-06 18:15:32 +0000 UTC
2019-06-06 18:15:32 +0000 UTC
Resolved
7
FALSE
2019-06-05 21:28:36 +0000 UTC
2019-06-05 21:28:36 +0000 UTC
Resolved
7
TRUE
2019-06-06 18:10:32 +0000 UTC
2019-06-06 18:10:32 +0000 UTC
Resolved
8
FALSE
2019-06-05 21:30:53 +0000 UTC
2019-06-05 21:30:53 +0000 UTC
Resolved
8
TRUE
2019-06-06 18:10:03 +0000 UTC
2019-06-06 18:10:03 +0000 UTC
Resolved
9
FALSE
2019-06-05 21:37:13 +0000 UTC
2019-06-05 21:37:13 +0000 UTC
Resolved
9
TRUE
2019-06-06 18:09:49 +0000 UTC
2019-06-06 18:09:49 +0000 UTC
Resolved
10
FALSE
2019-04-30 15:32:04 +0000 UTC
2019-04-30 15:32:14 +0000 UTC
Open
11
FALSE
2019-04-30 21:23:44 +0000 UTC
2019-04-30 21:23:46 +0000 UTC
Open
11
TRUE
2019-05-01 15:05:42 +0000 UTC
2019-05-01 15:05:43 +0000 UTC
Open
11
FALSE
2019-04-30 21:07:59 +0000 UTC
2019-04-30 21:08:01 +0000 UTC
Resolved
12
FALSE
2019-04-30 21:23:46 +0000 UTC
2019-04-30 21:23:49 +0000 UTC
Open
12
TRUE
2019-05-01 15:05:41 +0000 UTC
2019-05-01 15:05:42 +0000 UTC
Open
12
TRUE
2019-05-01 15:06:02 +0000 UTC
2019-05-01 15:06:04 +0000 UTC
Open
13
FALSE
2019-04-30 21:10:26 +0000 UTC
2019-04-30 21:10:28 +0000 UTC
Open
13
TRUE
2019-05-01 15:00:23 +0000 UTC
2019-05-01 15:00:25 +0000 UTC
Open
14
FALSE
2019-04-30 21:20:33 +0000 UTC
2019-04-30 21:20:35 +0000 UTC
Open
14
TRUE
2019-05-01 15:01:17 +0000 UTC
2019-05-01 15:01:19 +0000 UTC
Open
15
FALSE
2019-04-27 20:55:57 +0000 UTC
2019-04-27 20:55:57 +0000 UTC
Open
16
FALSE
2019-04-30 21:27:11 +0000 UTC
2019-04-30 21:27:12 +0000 UTC
Open
16
TRUE
2019-05-01 15:05:35 +0000 UTC
2019-05-01 15:05:36 +0000 UTC
Open
17
FALSE
2019-05-22 22:45:03 +0000 UTC
2019-05-22 22:45:04 +0000 UTC
Open
17
TRUE
2019-05-23 13:00:31 +0000 UTC
2019-05-23 13:00:34 +0000 UTC
Open
18
FALSE
2019-06-05 19:40:22 +0000 UTC
2019-06-05 19:40:22 +0000 UTC
Resolved
18
TRUE
2019-06-06 14:36:53 +0000 UTC
2019-06-06 14:36:53 +0000 UTC
Resolved
19
FALSE
2019-06-05 18:56:14 +0000 UTC
2019-06-05 18:56:14 +0000 UTC
Resolved
19
TRUE
2019-06-06 14:39:31 +0000 UTC
2019-06-06 14:39:31 +0000 UTC
Resolved
20
FALSE
2019-06-06 18:14:49 +0000 UTC
2019-06-06 18:14:49 +0000 UTC
Open
20
FALSE
2019-06-05 18:57:40 +0000 UTC
2019-06-05 19:06:06 +0000 UTC
Resolved
Convert date & time to DateTime
For each ID, min(Create Time) and max(Modify Time)
Diff in Days = DateTimeDiff([Max_Modify Time],[Min_Create Time],"days")
over SLA...
C:\ProgramData\Alteryx\Engine\Engine_10184_ae8bcb2e9ea946e2bedb2ddfdb5fa6a4_\Engine_16120_c4e569c5a13746398c488b36dc2f1404_.yxdb
Single
Profile
Horizontal
DateTime-Example