Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to count no of lines between two time slot:
Input data:
Line | Activity | Time |
1 | login | 9:15AM |
2 | listArtifact | 9:20AM |
3 | createArtifact | 9:40AM |
4 | logout | 10:00AM |
5 | login | 10:30AM |
6 | listArtifact | 10:40AM |
7 | createArtifact | 10:410AM |
8 | logout | 10:44AM |
9 | login | 10:46AM |
10 | listArtifact | 10:50AM |
11 | createArtifact | 10:52AM |
12 | logout | 10:55AM |
Desired output:
TimeLine | No of lines |
9:00AM-10:00AM | 3 |
10:00AM-11:00AM | 9 |
How to count it & i have to show it on Line Chart.
Thanks
I think you should use about intervalmatch(). It should be something like this.
table1:
load * from inputdata
table2:
load * inline[
start, end
9.30, 9.59
10.00, 10.59
....
];
intervalmatch:
intervalmatch(time)
load start, end
resident table2;
after this use join() to join tables