Get Free Trial

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

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

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:
Please let us know if this helps to resolve the issue.
Looking forward to your response.
Kind regards,

Tope February 3, 2021

Thanks Vera,

This works.


Please login or Register to Submit Answer