I need some help displaying data in a chart. Specifically, how can I build a chart that displays all my app’s transactions in a bar chart so that each bar represents one day, with the bar height representing the sum of the day’s transactions?
When I attempt this with the transaction total as the value, and the current date as the label, of course I get a new bar for each transaction. How can I sum up the day’s transactions into one bar?
Or do I need to schedule a workflow API that runs every day at midnight to create a new data point with the value being the sum of the day’s transactions?
Thanks in advance.