Hi, I am having some trouble using relations/rollup columns. I’m supposed to use those to sum month total and total by label, but I am not sure how. This is what I have: Date User Date2Num math column Label Amount 1/10/2025 User 1 Math date 2 number Label 1 10 1/11/2015 User 1 Math date …

Use a query column if you are comparing more than one column. Creating a query linking the label to the row label and the math column to the row math column. [image] Spiro: I tried matching Label to Label column (which makes no sense It makes sense because you are trying to find matching ro…

OK, So when the relations column shows “User1, User2” it is showing all the rows that match the relations. How do I sum by date or label then using rollup? I am not comparing 2 column at the same time. Sum by month, and another would be sum by Label.

Is the end result intended to be used as a number for reporting, or in a chart? [image] Spiro: OK, So when the relations column shows “User1, User2” it is showing all the rows that match the relations. Yes, that’s correct. [image] Spiro: How do I sum by date or label then using rollup? …

[image] Unique values to be added to new table Ask for Help You can use the technique described below:

If there is no correlation between date and user, you can created separate relations for each and then create Rollup columns to sum amounts through those relations.

@ThinhDinh Yes, that is correct. I was thinking of using this as a line chart (monthly sum) and bar chart (Labels on x axis), but it could be just a number to display somewhere in the app. I managed to do a “if then” column to display only single month, and then “rollup” column for “if then” colum…

Looking at this: Dynamically Filter your Data by TIMEFRAMES seems to be what I might need. And I think I found my fault, after relation column is created you get another “source” in the options which points to that relation. I was pointing to Table->RelationColumn instead of Relation->Amount

Help in sum by date and label

Ask for Help

Darren_Murphy February 17, 2025, 2:28am 5

Topic		Replies	Views
Rollup with Relation Column Ask for Help	12	1038	May 19, 2021
Sum Values for each Row Using Rollup Ask for Help	15	3574	October 3, 2020
How to sum values based on date (daily ,weekly, monthly) Ask for Help	18	1330	April 6, 2024
Variable & Relation Operation Ask for Help	4	301	May 9, 2022
Creating a SumIf Ask for Help	5	345	December 30, 2023

Help in sum by date and label

Related topics