Hi, I started using MongoDB towards the end of August and so far I’ve only had to make queries and inspect data for which I used Compass. Recently I’ve been tasked with creating more informative dashboards that require complex aggregations and drawing in data from multiple collections before doing some of the aggregation steps.
I’ve been going through Mongo’s M121 course and finally I was able to make some useful aggregation pipelines in Compass. Now I need to carry out these aggregation steps in charts to deliver useful information, but the problem is that
lookup is not available in charts (not in the query bar at least).
My problem is the following: Let’s say I have an aggrgation with the following steps:
Then, even though I’ve spent ages crafting my aggregation pipeline in Compass I need to redo most of it in charts. On top of this, the graphical interface for adding fields in Charts is hard to use, and several times it just reports that “no result was found” without further explanation. I’ve also tried to remove the
lookup aggregation from the Query bar and do it manually, but this also results in an empty dataset.
Is there any way to export some aggregation done in Compass directly to Charts? If not, most of the functionality of Charts is useless to me, since I can’t get any aggregation step to work once do the lookup, which is usually very early in the aggregation pipeline. There must be a better way to do this.
I’ve spent most of my day trying to figure this out, any help would be appreciated!