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…

[Thinh_Nguyen_Truong]

Hi @Alex_H , @DataGeekDude @david-ri ,

We are working on an upcoming feature Dataset View that can potentially addresses the problems discussed above. Would you mind check it out and share us your thoughts on it?

[Upcoming] Customizable Dataset Views - Product Releases - Holistics Community

We are working on an upcoming feature Dataset View, an enhancement to Holistics Datasets. This feature aims to let dataset creators design the ideal self-service experience for their end users by allowing them to customize the display of fields and models within datasets.

How it works: By default, datasets in Holisitics display all data models and fields in the order listed in the AML files. Now with Dataset View, creators can:

• Select fields: choose which fields to display in the dataset UI
• Re-order fields and models: define a customized order for fields and models within the dataset
• Group models or fields: put fields or models inside groups

[Thinh_Nguyen_Truong]

Hi @Alex_H @DataGeekDude @david-ri ,

We’re happy to inform you that an Open Beta version of Dataset view has been made available to everyone using Holistics 4.0 version.

🗂️ [Upcoming] Customizable Dataset Views

Launched: Dataset view in Open Beta Hi there, We are excited to announce that Dataset View is now in Open Beta - it’s available to everyone using Holistics 4.0 version right away (no sign up needed)! This version of Dataset view allows dataset creators to: Select fields: choose which fields to display in the dataset UI Re-order fields and models: define a customized order for fields and models within the dataset For more information, please watch our demo video: T…

This version of Dataset view allows dataset creators using AML syntax to:

• Select fields: choose which fields to display in the dataset UI
• Re-order fields and models: define a customized order for fields and models within the dataset

Check out our demo video below:

This feature is available in Open Beta and we’ll be back with more updates for this exciting new feature.

Feel free to share your feedback in this thread: [Launched] Dataset View in Open Beta