How do I add a count(*) measure to a view?

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:

1 Like