topic Grouping/ Bucketing Columns Together in App Development

Grouping/ Bucketing Columns Together

Asuod_ — Wed, 20 Nov 2024 19:13:17 GMT

Hello,

I have a wide table and I'm looking group certain columns together into three groups (Location, Personnel And Skills). For example, by selecting Location it will filter the table to only Location columns (Zip code, Address, City).

Columns: Zip Code, Address, City - Location

Columns: Job, Gender - Personnel

Columns: Sales Experience, Merchandising, Management - Skills

Any help on how to do this is appreciated. Thank you!

Re: Grouping/ Bucketing Columns Together

Qrishna — Wed, 20 Nov 2024 20:42:37 GMT

do you also have a fieldname called location, Personnel and Skills?

you could insert this piece in each respective group fields:

if(getselectedcount(Location)>=1, 1, 0) in the conditional show for all the three location fields. similarly do for others

Re: Grouping/ Bucketing Columns Together

Asuod_ — Wed, 20 Nov 2024 22:23:26 GMT

I do not have a fieldname called Location, Personnel and Skills. Those are the groups im looking to create, can you elaborate on the if(getselectedcount(Location)>=1, 1, 0) not sure how this would filter out everything besides the location fields.

Re: Grouping/ Bucketing Columns Together

Qrishna — Thu, 21 Nov 2024 16:12:22 GMT

provide some sample data and your expected output view. it would be much easier that way as the solution would be self explanatory.

Re: Grouping/ Bucketing Columns Together

Kushal_Chawda — Thu, 21 Nov 2024 21:35:38 GMT

@Asuod_ Create a Group column using inline table in script. If not you can even create this values using variable input object.

LOAD * inline [ Group Location Personnel Skills ];

I am assuming you have table object with all the dimensions. You can put below expression for each dimension belongs to that group in "Show column if" option for that dimension. For eg., for dimensions Zip Code, Address, City you can put below expression

=Wildmatch(GetFieldSelections(Group),'*Location*') If you are using variables to create Group values, you can use below expression Wildmatch('$(vGroup)','*Location*') Where vGroup is variable name

Similarly, you can use below expression for each dimension belongs to that group

=Wildmatch(GetFieldSelections(Group),'*Personnel*') =Wildmatch(GetFieldSelections(Group),'*Skills*')