So I have a system where an admin user can give other users “Points.”
I am able to track the total number of points that an admin user has given out as well as the creation date that individual points were given, who the points were given to, etc…
I’m trying to create a chart that shows how many points each user was given that month/week/day…etc…
Does anyone know how to do this? Screenshot of how the data is recorded below:
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.