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.
Please advice.
Thank you
here is the config
Hello, Rodrigo,
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/managing-data-presentation-json.
Please let me know if everything works as expected after defining data types.
Regards,
Tanya
adding the types fixed it. thank you