I have such kind of data in table:
Logging_Time Originator
12:30:00 20163
12:30:00 20160
12:30:00 20160
12:30:00 20161
12:30:00 20161
12:30:00 20161
12:30:00 20160
12:30:00 20163
12:30:00 20160
....
12:30:03 20162
12:30:03 199
12:30:03 199
12:30:03 199
12:30:03 199
12:30:03 199
12:30:03 199
12:30:03 20162
12:30:03 20163
12:30:03 199
12:30:03 199
12:30:03 199
12:30:03 199
12:30:03 199
12:30:03 199
12:30:03 20163
12:30:03 20162
12:30:03 20160
...
and I want to make something like this:
time should be used for X-axis, Y-axis should be a line chart, counting number of occurrences of same number during same time. Like:
199
199
20163
20163 199
20163 20161
20160 20161
20160 20160
20160 20160
--------------------------
12:30:00 12:30:01
so I need to get how many different events happening each second in sum and also separately
cannot decide how to start...
Looks like a job for a Pivot Table/Chart.
Group on the Time Values and count the occurrences of each time.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks