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

How to show Array as field

Ivan Firoavanti asked on March 18, 2020

Is it possible to simply show the value of an array in the Pivot? https://jsfiddle.net/61fnov4d/

1 answer

Vera Didenko Vera Didenko Flexmonster March 19, 2020

Hello, Ivan,
Thank you for writing to us and for providing a JSFiddle for illustration.
We would like to explain that Flexmonster supports two JSON formats:
1) An array of objects, where each object is an unordered set of name/value pairs
2) An array of arrays, where each sub-array contains ordered values.
More information about supported JSON formats can be found in our connecting to JSON guide.
Our team kindly suggests restructuring the JSON data the following way:

"Category": "Accessories",
"Color": "green",
"Quantity": 22,
"Test": "A"
"Category": "Accessories",
"Color": "green",
"Quantity": 22,
"Test": "B"

Here is a modified version of the JSFiddle showing the described approach: https://jsfiddle.net/flexmonster/sow71m4v/
Please let us know if this works and if you have any additional questions.
Best regards,

Please login or Register to Submit Answer