How to filter user-specific data by category from another table

Ask for Help
1

Hey guys,

I want to trigger some calculations from a specific spendings table in the user table.

Table for tracking spendings:

  • each entry per spending per user
  • category filter

image
image1368Ă—328 69.7 KB

In the user table:

How can I count for each user number of entries and total amount by CATEGORY?

Kind regards,
Martina

3

You can construct it like this.

  • Add a new table with all categories (say “Luxury goods” is a row, “Everyday spendings” is another row).

  • Add a template column to combine the signed in user’s email with the category. (It will look like this: johndoe@email.com - Luxury goods).

  • In your spendings table, create the same template column.

  • Create a multiple relation from the category table to the spendings table.

  • Rollup to get the count of spendings and sum of amount (2 rollup columns).

1 Like
4

Works really well. Thanks a lot @ThinhDinh

1 Like
5

It really work! Thank you @ThinhDinh

6

2 years ago there was no query column. Today you can do the same thing and filter by multiple columns.

1 Like