asked on February 14, 2024
Hey, Support Team
When I save the file loaded by json from the backend. I'm saving the key values of each column and not the dimensions.
For example if City and Sales are columns on the pivot table, when I save I want to see the slices as
{
dimensions: "City",
measure: "Sales"
} and not the data, similar to how the save functions work in the demo " https://www.flexmonster.com/demos/js/pivot-table". Right now I'm getting the actual value of each dimension and measure.
I also want to add the data source as a key value to json array.
Please let us know how to fix this.
Regards,
Melvin Paul
⋅ February 14, 2024
Hello, Melvin!
Thank you for your reply.
Kindly note that the data is saved into the report only when set as a JSON array using the data property. This was done to allow the opening of this report file in any other Flexmonster instance. To prevent showing the data in the exported report, we recommend loading the data via the filename parameter - URL to a JSON file or a server-side script that generates data. This approach is used in our JavaScript Pivot Table demo, allowing to save only the URL from which the data is loaded.
Please let us know if loading the JSON data via the filename property would work for you.
Best Regards,
Maksym
⋅ February 22, 2024
Hello, Melvin!
Hope you are doing well.
We are wondering if you considered loading the JSON data via `filename` property.
Please let us know if this solution fits your project.
Best Regards,
Maksym
⋅ March 21, 2024
Hello, Melvin!
Just checking in to ask if loading JSON data via the filemane property helped to achieve the desired export behavior.
Looking forward to hearing from you.
Best Regards,
Maksym
