PRODUCTX

The PRODUCTX function in Infoveave calculates the product (multiplication) of values in a dataset or column, considering a condition that filters which values are included.

Applicable to

• Calculated Columns
• Expressions

Return Value

• The product of all values in the dataset or column, based on the applied filter condition.

Remark

• PRODUCTX is useful for calculating the product of values while applying a condition to selectively include or exclude values. It allows for more nuanced, conditional multiplication-based calculations.
• PRODUCTX neglects null and blank values.

Syntax

PRODUCTX(<expression>,<condition>)

PRODUCTX 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 replaced with the actual widget and measure names.
Condition	A placeholder replaced with the condition filter.
Widget Name	The specific name of the widget used for data visualization in the Infoboard.
Measure	The name of the measure displayed or analyzed using the widget.
Dimension	The dimension column displayed or analyzed using the widget.
Dimension Value	The specific dimension items within the dimension column used for visualization in the widget.

Steps to Use PRODUCTX

1. Write the PRODUCTX function. For instance PRODUCTX(<expression>,<condition>)
2. Where expression equals 'Widget Name'[Measure] and condition equals [Dimension Name]="Dimension Value". Replace Widget Name, Measure, Dimension Name, and Dimension Value with your actual values.
3. To learn how to configure an Expression in Infoveave, visit Configure Expression.

Scenario You manage an Energy Offer Sales Dashboard and need to assess the impact of the product of offer quantity, considering specific payment behavior.

Scenario Details

• Dashboard Name Energy Offer Sales Dashboard
• Widget Name Quantity
• Measure Offers Sold
• Dimension Discount Types (categorizing customers based on payment behavior)
• Dimension Value “Pay on Time” (customers who pay on time)

Objective Use the PRODUCTX function to calculate the product of ‘Solar Customers’ in the ‘Solar Feed In’ dataset, exclusively involving customers with the “Pay on Time” payment type, ensuring the resulting product does not reach a critical threshold of 200.

PRODUCTX('Quantity'[Offers Sold], [Discount Type]="Pay On Time") < 200

PRODUCTX in Calculated Columns

Parameter	Description
Expression	A placeholder replaced with column names.
Condition	A placeholder replaced with the condition filter.
Column Name	The name of the column containing the values you want to analyze.
Filter Condition	A filter condition returns data points meeting the defined condition. Can be a string or numeric.

Steps to Use PRODUCTX in Calculated Columns

1. Write the PRODUCTX function. For instance PRODUCTX(<expression>,<condition>)
2. Replace <expression> with the required [Column Name] and <condition> equals [Column Name]="Filter Condition". Replace Column Name and Filter Condition with your actual values.
3. To learn how to add calculated columns in Infoveave, visit Calculated Columns under Sources.

Caution

Do not use double quotes when setting up a numeric as the filter condition.

Objective Find the product of QUANTITY sold where COUNTRY is Japan.

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	20
	Japan			43.7874	10
2024-01-18				32.3019	4
2024-01-22	Brazil	Cosmetics	28.335	23.0109	7
2024-01-26	Canada		20.185	23.0109	9
2024-01-04	France	Cereal	25.26	28.7964	9
2024-01-09	Brazil	Cereal	44.575	53.8155	8
2024-01-14	Brazil	Snacks	20.185		4
	Brazil	Cosmetics	40.485	46.1529	2

You can use the PRODUCTX function like

PRODUCTX([QUANTITY], [CATEGORY]="Japan")

The new calculated column “Unit Sold” will return 200 (considering nulls and blanks).

ORDER DATE	COUNTRY	CATEGORY	UNIT PRICE	MARKET PRICE	QUANTITY	UNIT SOLD
03-01-2024	Brazil	Baby Food	38.41	43.7874	2	200
07-01-2024	Japan	Spices	45.56	50.8155	20	200
	Japan			43.7874	10	200
18-01-2024				32.3019	4	200
22-01-2024	Brazil	Cosmetics	28.335	23.0109	7	200
26-01-2024	Canada		20.185	23.0109	9	200
04-01-2024	France	Cereal	25.26	28.7964	9	200
09-01-2024	Brazil	Cereal	44.575	53.8155	8	200
14-01-2024	Brazil	Snacks	20.185		4	200
	Brazil	Cosmetics	40.485	46.1529	2	200