Hello community! Hoping that you are feeling very well, I would like to know something: How can I get my Agency A column to count the times that each unique agency appears, that is:
ONFIRE appears 5 times, so I want you to count the number of times that agency appears
Create a relation linking the agency to itself. Then do a Rollup counting the rows in the relation.
How would the relationship be made? I tried to do it, but I couldn’t do it, I share the screenshots of how I was doing it
Your first attempt is correct, but you need to check the “Match multiple” box.
