I want to use the below events to generate a graph with an X axis of time (with units in days) and a Y axis of num_occurrences which would be the sum of the occurrences of that unique identifier (1501358-my_event_1, 1234567-other_event_1, etc). I would appreciate if answers could provide some information about what is happening. I’ve spent several days trying to figure this out and one of my biggest issues is answers are often just a query with no explanation for what any of it does)
The events would generate 3 series:
Series: 1501358-my_event_1
(6/8/23, 18)
(6/9/23, 5)
Series: 1501358-my_event_2
(6/8/23, 3)
(6/9/23, 0)
Series: 1234567-other_event_1
(6/8/23, 0)
(6/9/23, 7)
There could be a lot of events (100+) so I would like to be able to limit each line chart to X number of series and generate more line charts if necessary.
If there is a way to make this a lot simpler by formatting my data differently, please let me know. I have some flexibility with changing the data format. I can't combine the different events, but I can alter how the events are stored.
Events:
{
time: 6/8/23 10:00:00.213 PM
... other information ...
occurrences: {
1501358: [
{
event: my_event_1
num_occurrences: 10
}
{
event: my_event_2
num_occurrences: 3
}
]
}
}
{
time: 6/8/23 6:00:00.213 AM
... other information ...
occurrences: {
1501358: [
{
event: my_event_1
num_occurrences: 8
}
{
event: my_event_2
num_occurrences: 0
]
}
}
{
time: 6/9/23 11:12:12.123 AM
... other information ...
occurrences: {
1501358: [
{
event: my_event_1
num_occurrences: 5
}
{
event: my_event_2
num_occurrences: 0
}
]
1234567: [
{
event: other_event_1
num_occurrences: 7
}
]
}
}
... View more