Get Free Trial

Numeric fields not showing aggregations

kumar asked on September 5, 2017

I am using json inline datasource. I see an issue related to numeric field if contains null value in first object in an array. it’s considering a text column and not showing numeric aggregations(sum, max, min etc…) please try to load below data and pull Quantity into measures section and observe the functions.

var jsonData = [
"Country" : "Canada",
"State" : "Ontario",
"City" : "Toronto",
"Country" : "USA",
"State" : "California",
"City" : "Los Angeles",

Thanks & Regards,

1 answer

Tanya Gryshko Tanya Gryshko Flexmonster September 6, 2017

Hello Sunilkumar.V,
Thank you for writing. For your situation please try adding the first object in JSON array and define data types explicitly. This way you can specify that Quantity has type number. Please check this example: You can read more about different types in our documentation. Does it work for you?

Please login or Register to Submit Answer