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.
Hope you’re doing well!
Major MongoDB Connector updates have been introduced in the latest Flexmonster release, including performance optimization, logging, and cache management. Expanding all values is now possible with MongoDB as well – we thought you might find this interesting.
If so, feel free to check out the following blog post for more details: https://www.flexmonster.com/blog/mongodb-pivot-table/.
This is included in Flexmonster v. 2.9.0: https://www.flexmonster.com/release-notes/.
You are welcome to update the component. Here is our updating to the latest version tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/.