Dear visitor, despite all the challenges, our team continues operating at full speed.

We are ready to help with any questions you may have. Please fill out this quick form and we'll get back to you.

Fill the form
Get Free Trial

Measure aggregation SUM being chaged to count

Rodrigo Demicheli asked on March 21, 2018

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

Rodrigo Demicheli March 21, 2018

here is the config

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:
Please let me know if everything works as expected after defining data types.

Rodrigo Demicheli March 22, 2018

adding the types fixed it. thank you

Please login or Register to Submit Answer