I’m currently working on some models and explores where I want to try and reduce as much clutter in the explore as possible for the end user, whilst still allowing important fields to be accessible in drill-throughs in order to see line level detail. At the same time, some of these fields may need to be exposed in other explores.
I’ve currently been achieving this with a combination of using field/set lists in a model and duplicated dimensions e.g. application__id and application__id__hidden . However, this has a couple of problems: in the drill through data, the column has a stupid and potentially confusing name, and also it requires duplicating the dimensions which seems messy.
Is there another way of achieving this behaviour, by overriding the dimensions behaviour in the model itself?