This is a custom question. Can i change false to inactive and true to active
Can we get to know the underlying query for custom question?
@Anum https://www.metabase.com/docs/latest/users-guide/custom-questions.html#viewing-the-sql-that-powers-your-question
I am using mongo db
@Anum How would I know that, since you're not providing "Diagnostic Info" from Admin > Troubleshooting.
It's the same for Mongo.
1 Like
Thank you @flamber. I found the query. Can you suggest me how to add cases to a query.
[{"$group":{"_id":{"isActive":"$isActive"},"count":{"$sum":1}}},
{"$sort":{"_id":1}},
{"$project":{"_id":false,"isActive":"$_id.isActive","count":true}},
{"$sort":{"isActive":1}}]
For true, it should be active and for false it should be inactive
@Anum I don't know Mongo very well. I would recommend that you try searching the internet for how to do that.