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 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