Presight
  • 👋INTRODUCTION
    • What is Presight?
    • Core Concepts
      • Metrics
      • Events
      • Segments
        • Source Columns
        • Custom Segments
    • The Presight Workspace
      • Workspace Overview
      • The Data Docs
      • Data Library (Datahub)
  • ➡️DATA IN
    • Connect
      • Data Warehouse
      • Data Connectors
        • API Connector
        • Google Sheets Connection
        • CSV Import
        • Dimensional Dates (Dimdates table)
        • QuickBooks Online
        • HubSpot Connector
    • Sync
    • Tables & Columns
      • Browse & Edit
      • Primary Key
    • Governance
  • ⚙️MODEL
    • Data Relationships
      • Table Relationships
      • Hierarchy
    • Metrics
      • Create Metrics
      • Ownership & Permission
      • Deletion
    • Events
      • Creating Events
    • Custom Tables
      • Table Builder
        • Filter a Dataset
        • Simple Data Enrichment
        • Advanced Enrichment - Segmentation
      • Custom SQL Query
    • Segments & Custom Segments
      • Dimensions from Data Sources
      • Create a New Dimension
    • Formulas
      • Metric Formulas
      • Data Transformation Formulas
  • 📊ANALYSIS
    • The Data Docs
      • Explorations
        • Docs Widgets
      • Reports
      • Dashboards
      • Layout & Beautify
      • Organize
      • Collaboration
    • Data Widgets
      • Charts
        • Query Syntax
        • Data in a Chart
        • Interacting with a Chart
          • Breakdown
          • Chart Filter
          • Time Change
          • Chart Menu
          • View Constituent Records
          • Version views in Chart
        • Chart Configuration
      • Metric Table
        • Creating a Table
        • Interact with a Table
          • Adding Metrics
          • Adding Sections and Organizing metric list
          • Table Filter
          • Table Summaries
          • Quick Chart Creation from Table
          • Timeline Navigation
        • Table Menu
        • Table Breakdown
        • Breakdown Options
        • Interact with Table Metrics
        • [Advanced] Automatic Variance Calculation
      • Records Table
        • Accessing Data Records on-demand
    • Breakdowns & Filters
      • [Advanced] Dimension Path
    • Event Analytics
      • Event Funnel
      • Cohort
      • Event Path
    • Segmentations
      • Metric Segments
      • Filtered Segments
    • Ask AI (Beta)
      • Ask Presight
      • Presight AI in your Chat Tools
  • 📈PLANNING
    • Creating Versions
    • Interacting with Versions
    • Interacting with Future Data
    • Forecasting a Metric
  • 🏛️GOVERNANCE
    • Overview
    • Table Restriction
    • Metric Permission & Sharing
    • Doc Sharing
  • ⬇️DATA OUT
    • Export Data
Powered by GitBook
On this page
  • 1. Creating New Dimensions using existing Dimensions
  • 2. Create New Dimensions using formulas
  • 3. Review your newly created dimension
  1. MODEL
  2. Segments & Custom Segments

Create a New Dimension

PreviousDimensions from Data SourcesNextFormulas

Last updated 6 months ago

You can create New Dimension from Existing Dimensions or by using Formulas when viewing metrics in Table.

1. Creating New Dimensions using existing Dimensions

  • In Data Hub, tab Data, click + New and choose New Dimension

  • Fill Dimension Name, select Source Dimensions (Data Columns), and write Description (optional).

You can choose to create a new dimension from one single column or from many different columns.

  • Input conditions for the new dimensions.

When you finish adding conditions, you can choose to click Create "Others" for all the rest and Save.

2. Create New Dimensions using formulas

  • You can create a new dimension when breaking-down a metric from a table, at the searching bar for dimension name Search dimension or (type) = for formula.

  • Then formulate the conditions and Enter, a New Dimension with be created and automatically broken-down in the table.

  • This formulated dimesion will be saved as Draft in the working doc, and you can find it at the side bar. Dimension Name and Description will be automatically generated based on the formula.

This Draft status allows you to review and revise the dimension before saving and publishing it.

  • As it is still draft, you can change the formula by clicking at the dimension name.

  • You can Save the dimension or adjust it by clicking on the Edit icon. Once you save it, the dimension will appear in the Data list and it can be used in other docs, by you and by other team members.

You can choose not to save the dimension. The dimension will still stay in your doc and you can use it to breakdown other metrics in the doc.

3. Review your newly created dimension

Once you create dimensions from Source Dimensions or by saving it from Formulas, your dimensions will appear in the Data list, together with the related Table.

In the above example, the dimension is created when breaking-down metric Ordered Amount, which belongs to table Order Lines. So, the dimension will be located in the table Order Lines.

You can edit the dimension as other dimensions from data source in the table. Check how to edit a dimension in the link below:

⚙️
Dimensions from Data Sources