Updating visualization legends

This is a custom question. Can i change false to inactive and true to active

@Anum
https://github.com/metabase/metabase/issues/9312 - upvote by clicking :+1: on the first post

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.