PyMongo aggregation no result

Question

I try to query the average of 'clicks' from MongoDB database using PyMongo.

query_result = list(my_collection.aggregate([{'$group' : {'_id' : None, 'avg_clicks': {'$avg' : "$clicks"}}}]))

The result of the query is:

ok
result

Do you know what can be the problem?

Answer 1

Collection.aggregate returns a dictionary like

{'ok': 1 or 0, 'result': the_actual_result}

Thus

list(my_collection.aggregate(...))

iterates over the dictionary, getting the list of keys ['ok', 'result'].