I think I have found an issue with null fields. I have a jsfiddle to help me explain http://jsfiddle.net/kg4jyg5r/.
In this fiddle there are 2 records of data. The price in the first one is null and therefore the price column only allows Count even though the second price value is a number 23. If I change this around and make the first record price 23 and the second price value null . I get the correct aggregators sum, avg etc …
The question is is this a bug or how can I get it to ignore the fact that the first value is null.
Thank you for the interest on our component. The first value is usually used to determine the column type (i.e.
So, if the first value is null it will be determined by default as
string. Therefore, you should set column type explicitly.
Please refer to the updated sample demonstrating how to set the correct type for such case – http://jsfiddle.net/flexmonster/kg4jyg5r/1/.
For more details please read our documentation about JSON data types.
Please let me know if everything works fine.
Hi thanks for the quick response. That worked! thanks