Hello,
I'm new with Metabase, sorry for that
I connected Metabase to my MongoDb database, everything is Ok. The structure of the test collection (MongoDb) is quite simple (see below the JSON representation of a Booking)
{
"_id" : ObjectId("596626d3eb7961414ab9e300"),
"bookingDate" : ISODate("2008-02-08T23:00:00.000Z"),
"destination" : "Italie",
"pax" : 4.0,
"price" : 2653.0
}
I try to create a question in order to get a report with these information :
Destination , Sum of Pax, Sum of Price
The problem is when I add the second "view" "Sum of Price", this view doesn't appear in the table...
Below, the native query, may be it can help :
[{"$project":{"price":"$price","pax":"$pax","destination":"$destination"}},{"$project":{"_id":"$_id","___group":{"destination":"$destination"},"price":"$price","pax":"$pax"}},{"$group":{"_id":"$___group","sum":{"$sum":"$pax"}}},{"$sort":{"_id":1}},{"$project":{"_id":false,"sum":true,"destination":"$_id.destination"}},{"$sort":{"destination":1}}]
Does anyone was face to this kind of issue? Any help would be very appreciated.