I am currently running flexmonster-mongo-connector 2.8.14 and mongodb 3.3.0.
When the fields are returned from the flexmonster-mongo-connector, the aggregation available for the string field is only [“count”], and the default ‘distinctcount’ aggregator for string does not appear.
We have tried forcing the ‘distinctcount’ aggregator into the react pivot table by modifying the response returned from flexmonster-mongo-connector, but after trying to do a ‘distinctcount’ on the react pivot table, the flexmonster-mongo-connector returns the following error, from mongodb.
“the field ‘title_!distinctcount’ must be an accumulator object”
May I know how I should proceed from here?
Thank you for posting your question.
Kindly note that the
Distinct Count aggregation is not provided in the Flexmonster MongoDB Connector by default because
Distinct Count is not represented in MongoDB in the first place.
Still, we are currently considering implementing this aggregation on the side of the MongoDB Connector – we cannot provide you with a precise ETA at the moment but we’ll make sure to inform you when it is introduced.
Please let us know if you have any other questions we can help you with in the meantime.