For every view in Omni, we automatically generate a COUNT(*)
measure for you. You’ll find this measure in your field picker, with the name [View Name] Count
, e.g. Users Count
.
Since COUNT(*)
doesn’t depend on a particular field (i.e. it’s counting any row in your table, regardless of column value), you’ll only ever need one measure with this definition. If you’d like to have a count(*) measure with a filter (creating a filtered measure), you can duplicate the field and then add a filter to the copy:
If you’re ever unsure if your Count
measure is a COUNT(*)
or a COUNT(DISTINCT)
, you can pop open the SQL tab to check: