Hello,
I have events in the following format (ordered from oldest to newest😞
buyer=1 open_cases=3
buyer=1 open_cases=2
buyer=1 open_cases=5
buyer=2 open_cases=6
buyer=2 open_cases=1
Cases can be opened or closed during the day and "open_cases" can increase and decrease over time for a specific "buyer". I would like to visualize a timechart of the sum of every "open_cases" we have every day for each buyer.
So first we need to retrieve the last number of open_cases by buyer :
buyer=1 open_cases=5
buyer=2 open_cases=1
The sum them up:
sum_open_cases=6
and then create a timechart that shows the daily trend of "sum_open_cases". How can I achieve this?
... View more