PRODUCT

The PRODUCT function in Infoveave is used to calculate the product of values within a specified column.

Applicable to

• Calculated Columns
• Expressions

Return Value

The return value of the PRODUCT function is the product of all the values within the column.

Remark

• The PRODUCT function is particularly useful when you need to find the cumulative result of multiplying values together, such as calculating the overall impact of multiple factors.
• PRODUCT function is used only for numeric values.
• PRODUCT function cannot be used across date and strings.
• PRODUCT function neglects all nulls and blank values.

Syntax

PRODUCT(<expression>)

PRODUCT in Board Expression

Note

Expressions help you add visual effects to your dashboard through widget-specific conditions. It is important to note that the Expressions are not meant to manage or modify data.

Parameter	Description
Expression	A placeholder in a function that is replaced with the actual widget and measure names.
Widget Name	The specific name or identifier of the widget being used for data visualization in the specific Infoboard.
Measure	Represents the name of the measure that is being displayed or analyzed using the widget.

Steps to Use PRODUCT

1. Write the PRODUCT function. For instance PRODUCT(<expression>)
2. Replace <expression> with 'Widget Name'[Measure]. Replace Widget Name with the actual name of your widget and Measure with the corresponding measure name.
3. To learn how to configure an Expression in Infoveave, visit the section Configure Expression.

Scenario You are responsible for managing a Solar Energy Dashboard in Infoveave, and your primary objective is to monitor the cumulative impact of solar customer numbers and total customer numbers on a key performance indicator. Specifically, you want to calculate the product of total sales quantity. You then use this product to evaluate whether it surpasses a predefined threshold.

Scenario Details

• Dashboard Name Energy Offer Sales Dashboard
• Widget Name Offer Quantity
• Measure Net Product of Offer Sales

Objective Your objective is to demonstrate how the PRODUCT function can be utilized to calculate cumulative impacts within your dashboard and trigger actions based on predefined thresholds.

You can use the PRODUCT function like this

PRODUCT('Offer Quantity'[Net Product of Offer Sales]) > 1200

PRODUCT in Calculated Columns

Parameter	Description
Expression	A placeholder in a function that is replaced with the column names.
Column Name	The name of the column in the dataset or Datasource that contains the values you want to analyze.

Steps to Use PRODUCT in Calculated Columns

1. Write the PRODUCT function. For instance PRODUCT(<expression>)
2. Replace <expression> with [Column Name]. Replace Column Name with the actual name of your column required.
3. To learn how to add calculated columns in Infoveave, visit the section Calculated Columns.

Objective Consider that you have the below sales dataset, your goal is to find the net product of the QUANTITY sold.

ORDER DATE	COUNTRY	CATEGORY	UNIT PRICE	MARKET PRICE	QUANTITY
2024-01-03	Brazil	Baby Food	38.41	43.7874	2
2024-01-07	Japan	Spices	45.56	50.8155