All Collections
Creating Dimensions in the Data View Editor
Creating Dimensions in the Data View Editor

No code creation of buckets and drill through dimensions

Liron Baram avatar
Written by Liron Baram
Updated over a week ago

Introducing Dimensions

Using Astrato's dimensions, create special dimensions that will improve the user's ability to find insights in the data and improve the interactivity of the dashboards and analytics experience.

Dimensions created in the data-view are available in all workbooks connected to the data view.
Using dimensions ensures efficient management of data assets. Editing a dimension will automatically update all the workbooks and charts using the specific dimension.

There are three types of dimensions:

  • Simple- You can use any single field, define a custom format, and give it a user-friendly name

  • Width_Bucket- Grouping numeric field values into equal range groups. This dimension lets users see a field distribution and focus on the right groups.

  • Drill-through- Define a list of fields that will be used in visualization for drill-down and drill-through actions.
    Drill-through dimensions solve the next question challenge. After the user finds and interesting insight and focuses on a data point, he can easily change the dashboard display to new dimensions, looking for more insights.

Dimensions creation is done with a complete no-code experience, enabling all users to create all types of dimensions.

Please note: Dimensions are not supported with Google Sheets.

Building your Dimension

Creating a Dimension

There are two options to create a dimension:

  1. Fast creation- click on the icon near the field and select the option: add dimension.
    This will create a new dimension with the field name.
    This method only supports single-field dimension types.

  2. Left panel dimension menu- Click on the +icon in the dimensions section in the left panel and select the type of dimension to create.

  • Create a Single field dimension.

  1. Select a field to use

  2. Select the format for the field (format options depend on the field type).

  3. Give the dimension a user-friendly name

  4. optional- add a description to the dimension.

  5. Click Create. You can now use the dimension in your workbooks and data-explorer.

  • Create a Width_Bucket dimension.

  1. Select a numeric field to use

  2. Define the min and max values for the buckets(Astrato will automatically fill these values from the field)

  3. Define the number of buckets- this number will define the number of groups that will be created in the dimension.

  4. Define the format- define the numeric format for the dimension- optional.

  5. Include out-of-range buckets - this check box will determine how to display values that are either above the max value set for the dimension or below the minimum value.
    When checked and if there are values outside the range a new bucket will be created. If not checked all out-of-range values will be mapped to the null value bucket.

  6. Give the dimension a user-friendly name.

  7. Show distribution- see a preview of the distribution created by the dimension settings, and make any adjustments to create a usable distribution.

  8. Click Create. You can now use the dimension in your workbooks and data-explorer.

Create a Drill-Through dimension.

  1. Select the list of fields to use in the dimension.

  2. Arrange the fields selected in the desired order. This order will be the order the fields will be presented to the user.

  3. Click Create. You can now use the dimension in your workbooks and data explorer.

Did this answer your question?