Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi community,
I have the following scenario
ID | System | company | start_date | finish_date |
1 | AAAA | XPTO | 22/07/2021 08:30 | 22/07/2021 10:15 |
2 | BBBB | XPTO B | 22/07/2021 11:30 | 23/07/2021 11:30 |
3 | CCCC | XPTO C | 22/07/2021 11:30 | 23/07/2021 11:34 |
4 | DDDD | XPTO D | 23/07/2021 08:45 | 23/07/2021 11:30 |
I need to create a metric that only considers ids 1 and 3, as the time of ids 2 and 4 are contained within the period of id 3.
It's possible?
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
25 | |
19 | |
16 | |
10 | |
7 |