🗂️ Launched: Custom Dataset Views

Product Releases
1

Previously, we shared with you an initial glimpse into our development process for the Dataset View feature in this early announcement. After two months of development, we’re glad to announce the official launch of Custom Dataset Views.

Here’s what we arrived at:

Concept

When designing new datasets, it can be quite challenging to strike the right balance between “comprehensiveness” and “usability”.

  • Comprehensiveness: It’s important that the dataset involves a wide range of relevant information to provide a comprehensive view.
  • Usability: The dataset should also be user-friendly, allowing users to quickly find the information they need. A usable dataset should be well-organized and easy to navigate.

To address this challenge, we introduce a feature called Custom Dataset Views. This feature allows data analysts to curate the display of fields and models within datasets. With custom dataset view, analysts can:

  • Reorder fields and models to highlight frequently used models and fields by putting them on top.
  • Hide fields and models that are not relevant to end users.
  • [New] Group relevant fields and models to provide better context.

How it works

Creating views in dataset defnition

By default, in dataset UI:

  • Fields are grouped by dimensions and measures, then displayed by the order listed in model files.
  • Models are displayed by the order listed in dataset files.

To create a custom dataset view, data analysts can define a view parameter in the dataset definition.

Example syntax 
Dataset ecommerce {
  label: 'Ecommerce'
  models: [users, products, orders, order_items, dim_dates, categories]
  relationships: [
    relationship(orders.user_id > users.id, true),
    relationship(order_items.product_id > products.id, true),
    relationship(orders.created_date > dim_dates.date_key, true)
    relationship(products.category_id > categories.id, true)
  ]

  view {
    model orders {
      // field id
      field status
      field created_at
      field user_id
      field discount
      field delivery_attempts

      group order_status_tracking {
        field created_date
        field total_orders_count
        field delivered_orders_count
        field cancelled_orders_count
        field refunded_orders_count
      }
    }
    model order_items
    model users

    group product_info {
      model products
      model categories
    }
    // model dim_dates
  }
}

Using Custom Dataset Views in Exploration

When a dataset has custom views, the view is displayed by default. This makes it easy for end users to get started with curated datasets. You still have the option to switch to the original field list if you prefer.

For more details information, check out our documentation: Custom Dataset View | Holistics Docs

Notes: Custom Dataset Views is only available for customers on Standard plans and above for Holistics version 4.0. If you have any feedback or suggestions for future updates, please don’t hesitate to let us know. :point_down:

2 Likes
5
6