Custom sets

You can create custom sets, which can be used to classify values in a list that you can then reuse across multiple analyses. ThoughtSpot now supports custom column sets. A column set is a custom group of values from a single column. Custom sets are community objects which remain when you navigate away from the Search Data page. When a set is initially created it is only available to the creator. When a set is used in an Answer or Liveboard, and the Answer or Liveboard is shared with specific users or groups of users, the set is then available for use as a community object.

Custom column sets are in early access and off by default. To enable this feature, contact ThoughtSpot Support.

To create a custom column set, first decide what type of set you want to create. For example, you can use custom column sets to define regions with specific countries included or excluded. To create a custom column set showcasing this defined list of values, follow these steps:

  1. Navigate to the Search Data page by clicking the Search data button in the top navigation bar.

  2. Click Add and select Column set.

    Add column set
  3. Select a Base column from the drop down.

  4. Select either Conditions or Bins under Define groups.

    Conditions allow you to create groups using operators.

    Bins allow you to create groups based on bins of specified sizes with a minimum and maximum values.

  5. Enter your desired parameters for the conditions or bins.

    Create column set
  6. To add multiple conditions click Add condition.

  7. To add multiple groups clcik Add group.

  8. For conditions, you can choose to show remaining values as either Individual values or as a Group. If you choose to group the remaining values, you can enter a name for the group.

    create set
  9. Enter a Set name.

    The name appears to identify the set for future use.

  10. Optionally, enter a Set description.

  11. Click Create.

Was this page helpful?