asked on July 28, 2021
Hi team,
I'm investigating the way if we can add a custom column in the Pivot table.
The idea is to add an editable column on the pivot table. Then we allow users to add comments on that column.
You can see example screenshot below: the Remark 1 column is the custom column we would like to add. Please note that we don't have Remark 1 in the data set.
https://user-images.githubusercontent.com/3611073/127266566-b05c4ed5-b033-4dfd-b22c-6aafefa6ac82.png
Could you pls let me know if Flexmonster supports the API to do that?
Thank you in advance!
Best regards,
Hung
⋅ July 28, 2021
Hello, Hung,
Thank you for posting on our forum.
Flexmonster is a tool for a visual representation of the existing data, therefore, it does not provide the possibility to add additional editable columns.
Feel free to contact us if other questions arise.
Best regards,
Illia
⋅ August 5, 2021
Hi Illia,
Thanks for your answer.
I have another question. I wonder if Flexmonster provides the API to get the aggregated data in the pivot table? It is something like exportTo but with JSON format https://www.flexmonster.com/api/exportto/.
Thank you in advance!
Best regards,
Hung
⋅ August 5, 2021
Hello, Hung,
We would like to explain that Flexmonster is a tool for data visualization and analysis. The component is not designed to be used as an aggregator. Its capabilities on this point are limited with exporting the data to the predefined set of formats (CSV, Excel, PDF, etc.) and integrating with third-party charting libraries using the `getData` function.
Do not hesitate to contact us if other questions occur.
Kind regards,
Illia
