Categorize expenses by location

brian

This snippet provides an endpoint for categorizing expenses based on the location where the transaction occurred.

• Snippet: https://www.xano.com/snippet/6SPxQGdC
• Loom walk-through: https://www.loom.com/share/e1ff94ff741e494897dfa6a9f138e396
• How to add a Snippet: https://docs.xano.com/xano-features/snippets/preview-and-add-a-snippet

It features:

• GET /expense_by_category: an API that queries all transactions and summarizes the amount spent by the category of the location.

You can use this snippet to learn how to Query All Records and:

• Join two tables
• Bring a column in from a related table using eval
• Bring data in from a related column using addon
• Aggregate the results and sum the amounts

Feel free to add suggestions, requests, or questions in the comments!