Conditional expressions and boolean logic in creating calculated metrics

tableaucommunity@tableau.com — Tue, 05 Nov 2013 19:18:43 GMT

As a Tableau newbie I have what I imagine is a very basic question-

I am trying to create a calculated metric called "AppointmentVolume". I would like to just do a countd on an attribute called ConfirmationNumber (dimension) where another dimension, "IsCancelled" is 'false'. Both attributes are in the same table

I have tried a number of different statements, and all show up as 'invalid'

I thought it would be something like:

countd(ConfirmationNumber) WHERE (IsCancelled='False')

Any tips would be greatly appreciated- its driving me nuts!

Content in Tableau Community Forums

Conditional expressions and boolean logic in creating calculated metrics