---
title: Creating dataset expressions for measures
description: Applies to v4.5 and later.
---

[Skip to content](https://help.intuitivebusinessintelligence.com/creating-dataset-expressions-for-measures#main-content)

English

Show submenu for translations

![Intuitive logo RGB-1.png\]](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/Intuitive%20logo%20RGB-1.png?height=40&name=Intuitive%20logo%20RGB-1.png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Go to weareintuitive.com](https://weareintuitive.com/)

[Go to weareintuitive.com](https://weareintuitive.com/)

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Help Center](https://help.intuitivebusinessintelligence.com/?hsLang=en)
2. [Intuitive Dashboards Core Software](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en)
3. [Datasets](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#datasets)

# Creating dataset expressions for measures

## Applies to v4.5 and later.

When building a dataset, you can create calculated measure columns from any of the source columns found in the datafeed, using the expression builder.

To create a measure column expression:

1. Create or Edit and existing dataset.  
   ![DatasetMenuEdit](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/DatasetMenuEdit.jpg?width=332&name=DatasetMenuEdit.jpg)
2. In the dataset builder, [drag-and-drop a new column from the datafeed to the dataset](https://help.intuitivebusinessintelligence.com/creating-a-dataset?hsLang=en).  
   **Note**: The original column selection for a measure column is entirely arbitrary as this can be changed to any column in the datafeed via the expression builder.
3. Open up the Column Property dialogue box by clicking on the column header in the dataset. Set the column name and select the Category **Measure**.   
   ![DatasetColumnType](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/DatasetColumnType.jpg?width=394&name=DatasetColumnType.jpg)
4. Now type an expression directly or open the *expression editor* via the ![DatasetIconExpression](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/DatasetIconExpression.jpg?width=37&name=DatasetIconExpression.jpg) Icon.  
   ![DatasetExpressionEditor\_01](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/DatasetExpressionEditor_01.jpg?width=485&name=DatasetExpressionEditor_01.jpg)
5. In the expression editor, you can see the list of available datafeed columns on the left, as well as the function buttons that can be attributed to them i.e. sum, count etc. The large text panel at the top shows the current expression.
6. To create an expression, you can type it free hand or search and select the column from the datafeed list and specify the function to apply e.g. **Sum**. It will be inserted into the expression automatically as *Sum({Column\_Name})*.  
   ![DatasetExpressionEditor\_03](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/DatasetExpressionEditor_03.jpg?width=655&name=DatasetExpressionEditor_03.jpg)  
   The example above shows a typical expression which calculates the % of mono pages being printed.
7. You can also expand the expression using the standard mathematical operators ie + - \* / and add parentheses (). The order in which calculations take place conforms to standard [BODMAS](https://en.wikipedia.org/wiki/Order_of_operations) principles.
8. Once you have created the expression, you will need to **validate** itto make sure it has been entered correctly before **saving** the expression, the column properties and the dataset.
9. To see the derived values in the dataset column, you will need to **save ![sc62](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/sc62.png?width=33&name=sc62.png)** the dataset, at which point the software will perform the final calculations.  
   **Note**: When a measure is placed on a chart/grid/gauge, the system will perform the dynamic calculation required, automatically grouping by the chosen attributes present.

- [Intuitive Dashboards Core Software](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#main-content)

    - [Getting Started](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#getting-started)
    - [Viewing Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#viewing-dashboards)
    - [Interacting with dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#interacting-with-dashboards)
    - [Filters](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#filters)
    - [Connections](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#connections)
    - [Datafeeds](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#datafeeds)
    - [Datasets](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#datasets)
    - [Components](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#components)
    - [Creating Dashboards and Components - Overview](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-dashboards-and-components-overview)
    - [Creating Components](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-components)
    - [Creating a Dashboard](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-a-dashboard)
    - [Administering the System](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-the-system)
    - [Administering Users](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-users)
    - [Administering Groups](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-groups)
    - [Security Filters - V5.2 and earlier](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#security-filters-v5-2-and-earlier)
    - [Security Filters - V5.3 Onward](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#security-filters-v5-3-onward)
    - [Embedding Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#embedding-dashboards)
    - [Configuration File](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#configuration-file)
    - [Installation & Configuration Guide](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#installation-configuration-guide)
    - [Version History](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#version-history)
- [Intuitive for PaperCut V2](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#main-content)

    - [Installing Intuitive for PaperCut](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#installing-intuitive-for-papercut)
    - [Viewing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#viewing-papercut-dashboards)
    - [Editing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#editing-papercut-dashboards)
    - [Intuitive for PaperCut Demonstration Videos](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#intuitive-for-papercut-demonstration-videos)
    - [Intuitive for PaperCut FAQs](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#intuitive-for-papercut-faqs)
- [Intuitive for PaperCut MF V3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#main-content)

    - [Installing Intuitive for PaperCut Version 3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#installing-intuitive-for-papercut-version-3)
    - [Viewing the dashboards - Intuitive for PaperCut Version 3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#viewing-the-dashboards-intuitive-for-papercut-version-3)
    - [Editing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#editing-papercut-dashboards)
    - [Intuitive for PaperCut FAQs](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#intuitive-for-papercut-faqs)
- [Intuitive for SAFEQ](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#main-content)

    - [General Help](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#general-help)
    - [Software Installation](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#software-installation)
    - [Solution Expertise](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#solution-expertise)
- [Intuitive For Managed Print Services (MPS)](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#main-content)

    - [Intuitive for MPS - Overview](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-overview)
    - [Intuitive for MPS - Installation Steps](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-installation-steps)
    - [Intuitive for MPS - Import File Layouts](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-import-file-layouts)
    - [Intuitive For MPS - Loading the Data Warehouse](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-loading-the-data-warehouse)
- [Intuitive Cloud Services](https://help.intuitivebusinessintelligence.com/intuitive-cloud-services?hsLang=en)
- [Intuitive for PaperCut Hive V1](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-hive-v1?hsLang=en#main-content)

    - [Viewing the dashboards - Intuitive for PaperCut Hive](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-hive-v1?hsLang=en#viewing-the-dashboards-intuitive-for-papercut-hive)
- [Intuitive for SAFEQ Cloud](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#main-content)

    - [Intuitive Solution Expertise](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#intuitive-solution-expertise)
    - [Intuitive Software Provisioning](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#intuitive-software-provisioning)
- [Intuitive for Docuware](https://help.intuitivebusinessintelligence.com/intuitive-for-docuware?hsLang=en)
- [Intuitive for Print Management](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#main-content)

    - [Solution Knowledge](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#solution-knowledge)
    - [Technical Information](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#technical-information)
- [Intuitive for e-BRIDGE Global Print](https://help.intuitivebusinessintelligence.com/intuitive-for-e-bridge-global-print?hsLang=en)
- [Intuitive for e-FOLLOW Cloud](https://help.intuitivebusinessintelligence.com/intuitive-for-e-follow-cloud?hsLang=en)
- [FAQ](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#main-content)

    - [Connections](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#connections)
    - [General Enquiries](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#general-enquiries)
    - [Datafeeds](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#datafeeds)
    - [Datasets](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#datasets)
    - [System Compatability](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#system-compatability)
    - [Software Installation](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#software-installation)

[![Chill listening crop-3](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/Intuitive%20logo%20BLACK.png?width=102&height=24&name=Intuitive%20logo%20BLACK.png "Chill listening crop-3")](https://help.intuitivebusinessintelligence.com?hsLang=en)

weareintuitive.com Help Center

Copyright © 2026, Intuitive Business Intelligence Limited