Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Columns containing Integer of float with an empty cell of ‘(blank)’ cell do not aggregate

Answered
Tope asked on February 2, 2021

Good day,
I have a json data that have some data types of number that are (blank) and there is no longer an option to aggregate with sum, avg… etc. Only options are count, distinct count etc… 
So I figured since ‘(blank)’ is a string, I decided to use global localization to change the blackMember to “”. Although, I still didn’t see the aggregate options for sum, avg
 

2 answers

Public
Vera Didenko Vera Didenko Flexmonster February 3, 2021

Hello, Tope,
 
Thank you for reaching out to us.
 
For such cases, we kindly suggest specifying the data types for the fields. 
This can be done via the mapping property of the dataSource object.
Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/won83x15/
 
Please let us know if this helps to resolve the issue.
Looking forward to your response.
 
Kind regards,
Vera

Public
Tope February 3, 2021

Thanks Vera,

This works.

Regards,
Tope

Please login or Register to Submit Answer