If we apply a report of level 1, and there are more than 1 person assigned to the same space sharing the same parent organization of level 1, the legend only counts 1 headcount, instead of more. Next, if we apply a report of level 2, and there are 2 people sharing the same parent organization of level 2, but they are located in different spaces, the legend counts correctly 2 people, because they are located in two different spaces. But if these 2 people are located in the same space, when we apply the report of level 2, the same error would happen.
We needed to add a check box to the “Graphic Query Report Options” to enable the sum aggregation to sum fields on a color by graphic report even when multiple “Group By” resolves to the same record for the same space. Moving forward, we added a check box to the “Graphic Query Report Options” to enable, when checked, the associated sum fields of graphic report with a “Group By” that is the same “Group By” value for the same space.
For example, suppose that you configure to sum a field on an associated area allocation of a space, where we group by that allocation’s associated organization’s parent. If a space has multiple associated allocations with associated organizations that are different, but have the same parent, then this situations applies. Legacy behavior is to only sum the field on the first allocation for a space (for each unique “Group By”). With the check box checked, the sum of the fields on all allocations will be added. This behavior is similar to how “Group By” works. We will be adding documentation about this new check box, and looking at how to better document the limitations of “Sum”, as well as the configuration of “Count”.
[Admin: To see other related posts, use the Group By tag.]