**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.