Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

How to manipulate data

Resolved
Chris Anderson asked on January 29, 2020

Hi
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

Public
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,
Illia

Public
Chris Anderson January 31, 2020

Thanks for the detailed response Illia

Please login or Register to Submit Answer