Hi everyone,
I have a list with number values in a column ("Score") and I want to get the average of all those values. The smartest way I found to do this (is there a smarter way?), is to run a query for that column, then add up all values and divide it by the total count.
The output via history log looks like this:
Score Count: 2 ScoreCol: [{"Score":0.5},{"Score":0.714285714285714}]
Indeed, I have 2 items in that list. But why the heck does the query store the name of the column in the collection as well? I can´t figure out, how to change this behavior. And all my attempts to work around this and delete the name part from the collection have failed so far. Please help.