🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

How to manipulate data

Chris Anderson asked on January 29, 2020

Please see attached xls file.
Our system presents data to FlexMonster as a CSV flat file. I’ve provided a sample of what we get, the pivot I want to make and the problem I have. Please could you advise if there is a way to manipulate the data in such a way using FlexMonster or a way to get the pivot I need using the data as we have it now?
Thanks in advance

2 answers

Illia Yatsyshyn Illia Yatsyshyn Flexmonster January 30, 2020

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,

Chris Anderson January 31, 2020

Thanks for the detailed response Illia

Please login or Register to Submit Answer