Need help in creating a chart/report

Need help
1

All I want to do is to display a chart of how many cases each attorney had in a time period.

Example:

01/01/2015 to 12/31/2015

Chart Output Table
Attorney(Label) , # of cases (Value)
John, 35
Robert, 103
Carlos, 12

What is the best way to do that in Bubble? I assumed I had to build a new table to hold these values. I called it Chart Output Table. I realize I have to delete it every time I run a report

But how do I build this table dynamically? In other words, as a search (or a repeating group) finds each case, how do I tell Bubble to Add the Attorney (if not found in the Chart Output table) and add 1 to the Value, or if this Attorney was already created, just add one to the current value?

I’m struggling with this one. Any help would be appreciated. Thanks in advance

2

… in other words, how to dynamically add multiple data to one repeating group based on another repeating group?

3

Are you trying to do a repeating group inside the cell of a repeating group? If so, this is possible, you need to use the “Search for…” to set the type of the nested repeating group.