Hello, how is the concept of creating a basic trend chart for a monthly metric? I don’t quite understand how to fill in the X value and the Y value. I can’t find a much detailed explanation on the help.adalo.com either.
I have a collection that has many records of items that has a price. Let say it’s in Order Collection > Price field.
In January there are 10 records that has $5 each. February has 10 records that has $10 each. March has 10 records that has $20 each.
How to draw those data to the chart so it can shows a graphic something like this?
X : January, Y : $50
X : February, Y : $100
X : March, Y : $200