CSV Connector Column Calculations

Column Calculations
CSV Connector can dynamically aggregate data contained in a CSV file before it is loaded into the dashboard. Column Calculations identifies how each column of data is in the destination range is aggregated. Each column requires a column calculation key listed below.

Define column calculations range- CSV column calculations should be bound to a cell range (row) with the same number of columns as the destination range.

Define calculation index value-
1= List- Comma separated
2= Count- # Rows
3= Sum- Sum of values
4= Average- Average of values

Calculation Index
Single value index that identifies the column where calculations are applied. CSV Connector will locate all distinct values within the column and then run calculations for all other columns  based on column calculation definitions.