[Solved] Create a chart showing data from previous week

You can set this up using a "Do a search for that references the current date and time and then adjusts the number of days by a negative number (ex 7 for a week). Below is an example of User’s created in the last 7 days, but the logic carries for point records.

In your case, you would change the setup to be Search for Point Records’s Given Amount:sum. (Which would sum up the count of points of all of the matching records). Note that you’d want to build out other constraints for the Given By, etc.

As you want to do more complex visualization, you’d want to make use of the “Group by” function (ex. create a bar chart that displays by day). More info here.

Dan (creator of LearnTo - 115+ Bubble tutorials and on-demand coaching)

1 Like