Hi all,
I would like to have a numerical property for my elements, more specifically the purchase price of the device, do some aggregations on it with GQI and put the results on a dashboard.
When I add a custom property 'cost', fill in a number as the value for my elements and then query those elements with that property with GQI, it seems like the values are interpreted as a string instead of a number since I can only do filtering and counting on it, no sum/average/min/max etc.
Is there any way to specify that this property should be interpreted as a number?
Hi Reinout,
There are only two types for properties right now: strings and discretes. It's not possible to define a property as a numeric at this moment.
You are correct in assuming that all property values are interpreted as a string. GQI currently doesn't take the type of the property into account. I've created a task for this and have put it on our backlog. I'll update this answer once it's resolved.
I’ve clarified my answer a bit more. It’s currently not possible to have numerical properties.