Measures

Measures are quantitative data points or values that can be aggregated (summed, averaged, counted, etc.) and are typically numerical. Measures represent metrics or facts or KPIs that provide insights into the performance of a business or system. In ViewZen Analytics, we support many inbuilt aggregation functions to allows users to get the required measures in quick time and without calculation errors.

While measures are typically derived from numerical data, they can also be created using text or date-based fields.

Data Field Type
Inbuilt aggregation functions that can be used

Text

Count, Distinct Count

Date

Count, Distinct Count

Numerical

All

Tip

If your question is related to How Much? How Many?

Create a measure for it.

Visual Components using Measures

The following visual components in ViewZen Analytics use Dimensions

Visual Component
Measures Supported
Remarks

Pivots

All inbuilt aggregation functions

Mutiple measures are supported. Each measure is a separate column. Measure gets repeated for each dimension value (column dimensions)

Grid / Table

Only for aggregate table

Multiple measures can be used. Each measure is a separate column.

Charts

Measures are supported only on the y-axis

Multiple measures can be used on a singe or multiple Y-axes.

Card

Only basic aggregations such as sum, average, minimum, maximum and count are supported

Only measure in a card is currently supported. To use multiple cards or to create a composite card, use Zones

Textbox

Multiple measures

Multiple measures can be added to a textbox visual data settings. They can be used using the INSERT configuration in the actual text.

Last updated