Hello, I am unable to find the proper solution to create a time series with two data sets.
I have set of Ticket things, with a submit date and close date and I want to produce a time series with two lines, tickets opened and tickets closed, per day.
Sounds super simple, but when I dig into the charts plugin, it turns into a huge task. I tried a couple plugins in vain.
I’d appreciate some help finding the right plugin and usage for that. Thank you.
Hii @umiumansa!
If i understand your problem correctly, you have a table called “Tickets”. Each ticket has a submit date and close date.
You can do display a chart which shows tickets opened, and closed everyday.
Am i correct?
Correct.
One approach would be to manipulate the data in the query that feeds into the chart with something called “group by” and “buckets”
Scan down this page in the manual for the word “bucket”
https://manual.bubble.io/core-resources/data/operations-and-comparisons
Thanks.
So I already figured out the group by day part but I still don’t know how to use that. I did group by and counts but then that’s about as far as I got.
I can’t get any of the graphs to produce what I need. The time series graphs I tried don’t allow to have different series. Some line graph plugins allow multiples series but I can’t figure out how to make them work and there’s near to zero documentation—as well as they are not time series, so it won’t populate days without data points.
So, I’m kind of looking for a working example I could follow.
No success on this one yet. Any suggestions perhaps?
Ahhh. Sorry i have been away.
I think grouping by date is the way to go. You can find the option by using the :group by operator, and select a date field, maybe created date or something specific, and set it to count.
Let me know if it works.
Hi, but then what graph to use? The line graph plugin takes only one series. How to inject another series?
Ah, the default bubble charts plugin only allows you to set one series. If you want to add multiple series you might want to look into other options like Charts.JS. Its a great plugin.
Ah I am about to buy it but couldn’t test to be sure. Let’s try.
Yeah, but you could check the plugin’s page for a demo editor. You could play around and know what the plugin can do 
This topic was automatically closed after 70 days. New replies are no longer allowed.
