Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to use set analysis to show the # and % of timestamps that are <= to 00:10:00 (10 minutes)
TimeStamp
0:05:12
0:15:00
1:02:32
0:09:00
0:10:00
0:06:52
Thanks for your help
Mark
0:01:31 |
0:21:32 |
0:09:40 |
0:11:07 |
0:15:09 |
0:05:36 |
0:09:44 |
0:19:07 |
0:26:12 |
0:23:36 |
0:29:46 |
0:17:52 |
0:01:31 |
0:21:32 |
0:09:40 |
0:11:07 |
0:15:09 |
0:05:36 |
0:09:44 |
0:19:07 |
0:26:12 |
0:23:36 |
0:29:46 |
0:17:52 |
0:01:31 |
0:21:32 |
0:09:40 |
0:11:07 |
0:15:09 |
0:05:36 |
0:09:44 |
0:19:07 |
0:26:12 |
0:23:36 |
0:29:46 |
0:17:52 |
Try:
Count({<MyField = {"<=$(=Timestamp#('00:10:00'))"}>} MyField)
Thanks Juan