Measure aggregation SUM being chaged to count

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

3 answers

Public
Rodrigo Demicheli March 21, 2018

here is the config

Public
Tanya Gryshko Flexmonster March 22, 2018

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/data-types-in-json/.
Please let me know if everything works as expected after defining data types.
Regards,
Tanya

Public
Rodrigo Demicheli March 22, 2018

adding the types fixed it. thank you

Please login or Register to Submit Answer