How to manipulate data

Hello, Chris
 
Thank you for reaching out to us.
 
The desired configuration can be achieved through adjusting the report object.
Detailed information about configuring the report can be found by the link: Configuring Report.
 
Please see an example we have prepared for you demonstrating the sample report allowing to adjust the desired configuration.
 
Also, our team has noticed that the column named "Grand Total" is included in the table; in the example provided above, the Calculated Value is used in order to create such a column.
More information about calculated values and ways to define them can be found following the link: Calculated Values.
 
As for the data passed to the component, we would like to kindly notice that belonging to the string data type, "Yes" and "No" values presented in your data set can be aggregated only with count and distinct count aggregations. Such an aggregation will treat both "Yes" and "No" values equally.
 
In order to avoid such behavior, we can recommend using one of the approaches described below:

• Change "Yes" and "No" values to 1 and 0. That will allow an applying the sum aggregation. Data set with 1 and 0 values is passed by default in the example we provided. The data set itself can be found on the line 36 of the example.
• Instead of "No" value, the member should contain nothing (""). Such an approach allows applying the count aggregation. In the example, press the "Change data set" button in order to change the data set to the one with "Yes" and "" values. An appropriate data set is placed on the line 59.

 
Detailed information about data types for CSV data source can be found by the link: Data Types in CSV.
 
We hope it helps.
 
Please contact us in case of additional questions.
 
Best regards,
Illia