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
Short answer: this is currently not readily possible.
At present, the only way to do this is to create a collection of ‘months’ and have the transactions linked to them, then do a magic text of that month’s > transactions > totals.
Alternatively, you could have a ‘total’ field in the month collection and for each transaction set the ‘total’ field to current month’s > total > + transaction value
The complex bit lies in telling Adalo what the current month is when a transaction is made. If you have a start date and end date field in the month collection, and then run a list of months restricted to start date is before current date and time and end date is after current date and time, showing only one result, and then put the ‘checkout’ button in that list, it will allow you to access the ‘current month’ to do this.
There is a feature request for what you’re after, here: Month & Year functions | Voters | Adalo - be sure to vote!
1 Like
Hi mate I do a sales per month by linking Google Sheets (or Firebase) with Adalo through Zapier. I send the sales creation date to Google Sheets. Google Sheets uses the formula =TEXT(A1,“MMMM”) to display the month, =TEXT(A1,“DDDD”) for the day and “YYYY” if you need the year. The form submit button triggers the creation of the new row in google sheets through zapier. A second “zap” sends the month text back to the same collection table in Adalo updating the current field. Works great and simple to set up. I do all my date related triggers in this manner. Then your monthly sales chart will look like a traditional one in excel with January, February etc.
I think it’s better to use a paystub service for that. At least it’s way easier. And as far as I know our company accountant uses this service to track all of company expenses.
Hey there. Creating charts can definitely be a bit tricky, especially when you’re not quite sure how to organize the data. IMO, it’s better to use paystub generators for that. If you don’t know how to make check stubs online you can use PaystubCreator, which can help you keep track of your gross pay, deductions, and other information, which can help create charts. Let me know if you have any other questions or need more help with creating your chart. Waiting for your reply.