Sumif and Sort in a repeating group

retaildropshipping · 2020-11-10T11:46:06.693Z

I have a Type called “completed”
In that I have a Thing called “name” and a thing called “profit”.

The same “name” shows up multiple times with different “profits” next to it.

I want to build a group that visualizes every “name” profit total and sorts it is descending order.

I also want the name to be automatically put into the list rather than me having to manually add new names as new people come into the thing’s list.

Thank you

ralphlasry · 2020-11-11T14:34:13.087Z

We are missing some context to this question making it very difficult to provide assistance.

Please explain what you are trying to do and we can hopefully help you do it.

How are you adding items to the Type ‘completed’?

retaildropshipping · 2020-11-11T14:39:03.321Z

So I invest in poker players. I am creating a dashboard I want to see how each person is doing, Profit/Loss.

While they are playing tournaments they input the information into an “active” tournament form. Once the tournament is complete, a new entry into the “completed” database is created with the following information.

buy_in, cash, profit, player_name

So what i want to do is create a column that would have the player’s name (without me manually adding each player as new ones come into the group) and then also have their profit/loss next to their name. I guess this would be done in a repeating group?

retaildropshipping · 2020-11-11T14:49:07.384Z

It would basically be the same thing as in excel filtering a column to only see unique IDs then doing a SUMIF on those unique IDS on the original column’s data

ralphlasry · 2020-11-11T14:51:32.782Z

Correct, this would be a repeating group.

Add a repeating group to your page.
Add two text elements to the first row of the repeating group.
Set the repeating group to datatype ‘completed’ and data source to 'search of ‘completed’
For the first text element insert dynamic data - [Current cells completed’s player’s name] and for the second text element insert dynamic data - [Current cells completed’s profit]

Screen Shot 2020-11-11 at 9.47.47 AM1900×1458 271 KB

Screen Shot 2020-11-11 at 9.48.43 AM1880×1452 261 KB

Does this make sense?

gf_wolfer · 2020-11-11T15:27:16.346Z

Sounds like if the player was a Data Type this could be easier and achieved using ‘Groupings’

I think the above would give you the original problem with the same player name being listed many times, instead of a Summed total of each players profit/loss

ralphlasry · 2020-11-11T16:02:50.838Z

Correct, I didn’t realize he was trying to combine all data per user.

retaildropshipping · 2020-11-11T16:22:31.402Z

Yes correct, need to have the Sum of profit by Name, but name needs to not show up multiple times. I will look into this grouping suggestion. Thank you