Hi, Is it possible to create custom grouping for the values of an attribute in the analytical designer without modifying the LDM? When I do this via a MAQL, I am then unable to add other metrics, values, attributes in the same table visualisation in a sensible way (they become separate rows. example I want to group team A, B, and C (attribute: Team name) and give them a custom name (e.g. leadership) , have a count of users associated to this group (which is the sum of the users in each of the three teams), then in column 3 have a sum of all the tasks associated to this group.

Hi Raffaella, this is a bit of a tricky one as it may requiring adding a new CSV dataset to the LDM. If you want to use grouped attributes in tables/charts seamlessly: • Create a small CSV with: • Team Name, Group Name • A, Leadership • B, Leadership • C, Leadership Upload it as a data upload dataset, link it via a dataset relationship in the modeler (yes, this does slightly touch the LDM, but very lightly), and use

Group Name

in Analytical Designer just like any other attribute. This is the most sustainable way to do custom groupings. If you want to group values (like Teams) and use those groups across metrics and attributes in a coherent table, the best practice is: • Use a mapping dataset (uploaded CSV) to create the groupings. • Link it to your Team attribute via LDM modeling. • Then use Group Name as a native attribute in visualizations — this will allow proper aggregation across both users and tasks per group in one table.