I have 2 tables 1) users and 2) companies
In users I have:
name company
user A comp B
user B comp B
user C comp A
In companies I have:
name
comp A
comp B
In my Repeating group for the companies I want to show:
company # users
comp A 1
comp B 2
How can I do this?
Hey @ewbubbleio. You can use group by operator on the users to group them by company and aggregate the count. See the repeating group settings below:
Then, in each cell, you can just display this two information:
Thank you for this quick response, however I am still not able to get the count. I did exactly as suggested. Please read “company” for “groups”
However the individual fields I don’t see the “current cell Grouping’s” option.
I also noticed that if there are any “groups” (companies) without a user they don’t show in the listing. I would still need to see those as well.
Any suggestions?
I guess your RG Text Users is inside another group in the repeating group cell. And this group has its data source set Current Cell's Grouping's groupings. Simply, you can reach the count directly under repeating group. If you want to pass it on to other groups, you can.
Another approach is more costly but it would show all companies. Your RG will have its data type to be Company and do a search for companies as its data source. And in each cell, you will do another search for users with this company as constraint and count them.
You are correct I do have the fields inside another group. I will remove that group and change the users to companies. Thank you for the help.
