Hi All,
Need some help with what should be relatively easy but I can seem to figure it out.
I have a data set of profits with a standard bubble date field.
I want to chart the profits and aggregate the amount into daily sum over a week. Or into weekly sum over the last 52 weeks or months into the last 12 months etc.
What is the best way to do this dynamically with the existing database?
thanks
Hi,
I meet the same issue and it seems that grouping works only with day or month!
What about week and year???
It’s a basic need to be able to agregate data this way!
Does Anyone have fixed that?
Okay, for those who meets the same issue…
To agregate date on a weekly basis you need to set Type of grouping to day and interval(days) to 7 like this :
I assume this would work the same for year : set type of grouping to month and interval to 12
I think this look back 7 days from today. Rather than a rolling week from say Monday to Sunday basis.
Not sure if it’s possible to aggregate data on weekly (Monday to Sunday).
Use this plugin rather than current date/time to establish a specific day of the week to start on: https://bubble.io/plugin/1-thing---day-of-week-1586702961647x650466979361587200
I have a dropdown where I filter my data by day, week, and months using conditions. This is how I archived it using the Chart Element by Bubble.
View per day condition
View data per week condition
View by Month
You will choose how you want to group your data on each all your conditions specified.
This topic was automatically closed after 70 days. New replies are no longer allowed.
