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
Thank you for reaching out to us.
The desired configuration can be achieved through adjusting the
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
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:
sumaggregation. 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.
""). Such an approach allows applying the
countaggregation. 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.
Thanks for the detailed response Illia