Menu
Download Free Trial

Numeric fields not showing aggregations

Hi,
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 = [
{
"Color":"green",
"M":"September",
"W":"Wed",
"Country" : "Canada",
"State" : "Ontario",
"City" : "Toronto",
"Price":174,
"Quantity":null
},
{
"Color":"red",
"M":"March",
"W":"Mon",
"Country" : "USA",
"State" : "California",
"City" : "Los Angeles",
"Price":1664,
"Quantity":19
}]

 
Thanks & Regards,
Sunilkumar.V

1 answer

Public
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: http://jsfiddle.net/flexmonster/2fajgm7z/. You can read more about different types in our documentation. Does it work for you?
Regards,
Tanya

Please login or Register to Submit Answer