Skip to content
Infoveave Help

Measures and Dimensions

Infoveave uses measures (numerical data) and dimensions (categorical attributes) to help you analyze and visualize data. Measures represent what you want to analyze, dimensions provide context, and hierarchies organize data.

Measures

Measures are numerical values that represent quantifiable data. They are typically the data points that you want to analyze, such as sales revenue, profit margins, or the number of products sold.

Infoveave allows you to create and aggregate measures to perform calculations like sum, average, minimum, maximum, and more.

Measures are usually displayed as numeric values in visualizations like charts and tables.

To define a measure, follow the below steps

  1. Identify the specific data table and column for which you intend to create a measure.
  2. Locate the designated column within the required table and proceed to click on the measure icon associated with the column. add measure window
  3. Add measure modal window will appear, allowing you to configure the measure.
    • The Table and Column fields are predefined based on your selection.
    • The Type field is also preselected, aligned with the data type of the chosen column.
  4. Among the key components of the Add Measure modal is the Aggregation field. Here, you can choose the desired aggregation function for the measure, which determines how values are summarized
    • Count Total count of values in the column.
    • Sum Summation of numeric values.
    • Average Mean value of numeric data.
    • DistinctCount Count of distinct values.
    • Min Minimum value in the column.
    • Max Maximum value in the column.
  5. Proceed to configure the properties of the measure, enhancing its interpretability and relevance
    • Prefix Prefix to be added to measure values (optional).
    • Suffix Suffix to be appended to measure values (optional).
    • Measure name Provide a distinctive name for the measure.
    • Format Define the desired display format for measure values.
    • Precision Set the decimal precision for numeric values.
    • Description Elaborate on the purpose and significance of the measure.
  6. Click on the Add measure button to finalize the configuration.
  7. The created measure will be available under Measures in the Measures and Dimension Panel.

Dimensions

Dimensions are attributes or categories that help organize and provide context to the data. They are non-numeric and typically include data like time, geography, product categories, or customer names.

In Infoveave, dimensions are used to slice and dice data, allowing you to filter and group data for more meaningful analysis.

Dimensions can be hierarchical, such as time with levels like year, quarter, month, and day.

To define a dimension, follow the below steps

  1. Identify the specific data table and column for which you intend to create a dimension.

  2. Locate the designated column within the required table and proceed to click on the dimension icon associated with that column.

  3. Select the Add dimension option, an Add dimension modal window will open, allowing you to configure the properties of the dimension. The table, column, and type fields are automatically populated based on your selection, simplifying the configuration process. dimension modal

  4. The following fields are essential in configuring your dimension

    • Dimension name Provide a descriptive name for the dimension to distinguish it from others.
    • Key column Choose the column that contains unique values acting as key identifiers for this dimension. These identifiers enable proper linking and referencing of data across different tables.
    • Order column Optionally, specify an order for the values within the dimension.
    • Description Elaborate on the purpose and significance of the dimension.

  5. If you wish to define a hierarchy within the dimension or establish relationships between tables, you can specify the following

    • Hierarchy name Define a hierarchy name to organize and structure the dimension.
    • The table, column, and type fields are automatically populated based on your selection, simplifying the configuration process.

  6. The following fields are essential in configuring your dimension

    • Dimension name Provide a descriptive name for the dimension to distinguish it from others.
    • Key column Choose the column that contains unique values acting as key identifiers for this dimension. These identifiers enable proper linking and referencing of data across different tables.
    • Order column Optionally, specify an order for the values within the dimension.
    • Description Elaborate on the purpose and significance of the dimension.

  7. If you wish to define a hierarchy within the dimension or establish relationships between tables, you can specify the following

    • Hierarchy name Define a hierarchy name to organize and structure the dimension.
    • Attribute An attribute represents a specific element or characteristic within a dimension that contributes to its hierarchy. Define the attribute that you want to include in your hierarchy. This could be a subcategory, subgroup, or any other relevant classification within the dimension.
    • Attribute key column For each attribute included in the hierarchy, you need to specify a key column that serves as a link to the related data. This key column provides a reference point for navigating and organizing data within the hierarchy.
    • Attribute name Specify the attribute’s display name.

  8. Click on Add attribute to add the hierarchy.

  9. Click on the Add dimension button to finalize the dimension’s configuration.