IT Solutions
Depend on us to get your organisation to the next level.
Sectors
BCN have a heritage of delivering outcomes through our cloud-first services and currently support over 1200 customers across specialist sectors.
About Us
Your tech partner
Data
A common question from our EasySPC users
2 min read
EasySPC currently allows up to two fields in the GroupBy well for each visual. This limit helps keep performance acceptable, as adding more fields can dramatically increase the number of data permutations and slow rendering.
However, in some cases, you can work around this limitation by combining two or more fields into a single calculated column — if your data allows it. For example, if you want to group by both Facility and Sub-unit, you can concatenate those into a single field to use as one GroupBy input, leaving the second slot available for another field like Unit Type.
Facility_Subunit_Combined = [Facility] & " - " & [Subunit]
GroupBy Measure 1 (based on the combined field):
Facility_Subunit_Filter = IF( ISFILTERED('YourTable'[Facility_Subunit_Combined]), CONCATENATEX( VALUES('YourTable'[Facility_Subunit_Combined]), 'YourTable'[Facility_Subunit_Combined], "|" ), "" )
GroupBy Measure 2 (based on another field, e.g. Unit Type):
UnitType_Filter = IF( ISFILTERED('YourTable'[Unit Type]), CONCATENATEX( VALUES('YourTable'[Unit Type]), 'YourTable'[Unit Type], "|" ), "" )
You can now drag both measures into the GroupBy well. Meanwhile, the individual fields (Facility, Subunit, Unit Type) can still be used separately in slicers and will interact correctly with the EasySPC visual.
Find answers to more common questions from our EasySPC customers