Venturing into an area that I haven’t ventured before and have been doing a lot of reading on how to best achieve what I need.
As I understand it, the out of the box Chart plugin in Bubble is limiting in that it requires a simplistic ‘x’ and ‘y’ values to plot on a chart. Without the brains to be able to :sum or :average data specified for a period. As an example where there is a list of Coupons redeemed which are associated to a Venue. It lacks the ability to work out and trend the number of coupons redeemed for a venue month-on-month.
So, therefore as I understand the data is either required to be manipulated and saved into a Thing that the Chart can handle given the ‘x’ and ‘y’ data points required.
So two questions:
With the use of other external resources (eg; Blockspring, Google sheets, etc.) what is the best way to export the raw data to be “summarized” and then fetch the data back into Bubble so that it can be handled by the Chart pluging?
The ‘y’ values of the chart below are stored in a field called Month (type: Text) which is populated by extracting the :month from Current Date/Time. Question is that the ascending order is not correct. - is this a bug with the plugin? changing the sorting to descending just shows the reverse.