I attached the config and the data json.
Is there a limitation on the measures when using sum?
I do not know what is happening I configure the measure to be SUM (this config works with other datasets) but when rendered it uses count and the measure behaves like a dimension.
here is the config
Thank you for writing to us.
Your measure is rendered using count because pivot table interprets it as a string value, not numeric. We suggest adding the first object to your JSON array and define data types there. For more details and examples please refer to our docs: https://www.flexmonster.com/doc/data-types-in-json/.
Please let me know if everything works as expected after defining data types.
adding the types fixed it. thank you