How to use a count metric in Superset?

[masterlittle]

Make sure these boxes are checked before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if any
• I have reproduced the issue with at least the latest released version of superset
• I have checked the issue tracker for the same issue and I haven't found one similar

I am using Superset and have a column with only two unique values. I want to create a bar chart with the counts of those two values. But I cannot see a count metric, only a count distinct which does not serve the purpose. Is there a workaround or am I missing something?

Superset version

0.20.6

Expected results

Actual results

Steps to reproduce

[vnnw]

I think you have to add the metric you want by manually writing a valid sql expression.

[masterlittle]

Yeah figured that out. But do I have do that for every table. Is there some way to add a metric as a global metric, available for each table?

[xrmx]

Nope, you do it manually or you script it.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.