Dataset Exploration: Customize display/ordering of models/fields

[huy (Huy Nguyen)]

Right now in the dataset exploration UI, the ordering of the fields and models are done alphabetically. This is troublesome because it doesn’t allow me to curate/customize what I want to present to the end users.

1/ In a star schema structure, I will want to put the facts model on top (and ideally expanded by default) so that end users’ attention are immediately brought to it.

2/ Within a model, I want the ability to reorder the fields, for various reasons:

• Most important fields (maybe measures) can be on top.
• I’m used to ID field being at the top of the list
• Grouping related fields together

3/ Will be nice to be able to add some Markdown-based README for the dataset, so that analysts can provide instructions to end users on how to use it (key use cases, special logic, etc).

I’d imagine some of these would be quite straightforward? For example, with the models and fields defined in AML, we should just list the fields and models in the order that they are defined in the dataset file and model file?

[Alex_H]

Agree that more options for presentation would be helpful - for me, by far the most valuable would be the ability to group dimensions or measures together and also to create drill down hierarchies which group into a single dimension group.

[DataGeekDude (Craig Wilson)]

@Alex_H

drill down hierarchies which group into a single dimension group

100% this type of thing would be useful.

@huy

models are done alphabetically

Being able to customise this would make models so much more user friendly. Anything that makes data easier to use by non-data people is a great thing

[david-ri (David)]

@huy

For example, with the models and fields defined in AML, we should just list the fields and models in the order that they are defined in the dataset file and model file?

I would prefer some form of sort_key or sort_order you apply to the measure/dimension in the model, rather than taking the order in which they appear.

There might be purpose to the order of dimensions, such as existing dimensions, followed by custom dimensions, and this may not be the order I actually want them displayed, but want to keep them in that order in the model.

[huy (Huy Nguyen)]

Just realized that there’s a similar request posted here by @Abdel

Add Folders in Datasets to group Fields

Introduction You will most probably recognize this. You open a dataset, and you need to browse through hundreds of fields to find the field you actually need. Also some field names might be very close to each other. When using naming conventions, you might get away with a better experience. But what if you could organize the dimensions and measures in folders? Feature suggestion As an Analyst, I want to be able to organize my fields in groups, for easier browsabiliy. Example folders: Reve…