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