Hello,
I’m trying to have a line graph or bar chart that tracks:
- Number of Things created by Date of the Month.
How is this possible with the Bubble chart plugin?
Use the :grouped by function. Group your Thing by creation date > Day. This will create a separate bar/line for each group, which is a grouping of users by creation date.
Set interval to 1 so that it’s 1 day per group (as opposed to X days)
Set start to the earliest group. In my image below I sorted users by date and used the first creation date, but you can also do something like current date/time :change month to 1 :change date to 1 (for start of year)
If you don’t skip empty groups, you’ll have an X value for groups/days even if there is no data for it. And you need to set an end date (because what’s an infinity graph 
)
Create an Aggregation for Count. This will tell Bubble to count the number of Things per group.
Set your value expression to “Current point’s (group’s) count”
Gaby at Coaching No Code Apps (formerly Coaching Bubble)
Courses & Products, Tutorials, Private Coaching, and High-level Development
14 Likes
Thank you. This was extremely helpful to me.
2 Likes
This topic was automatically closed after 70 days. New replies are no longer allowed.