5 Replies Latest reply on Nov 25, 2016 2:34 AM by Dilyana Suleymanova

Question to "IF" formula

Hi there

thi is my data set

Contact results     ID

Call                         1234

Email                       5677

Call                         7897

Call                         6780

Fax                         5678

Call                         2456

I would like to count all ID if the result = Calls and this is my formula:

If [Contact results] = "Call" then countd [ID]

end

Unfortunately it doesn't work. I don't know why. Any ideas?

Thanks!

DS

• 1. Re: Question to "IF" formula

It's not clear exactly what you're trying to do.  If you drag Contact Results on to Rows, and Number of Records into the table, then you will get the counts for each type of contact result.

If you only want the count to be done when the Contact Result is Call, then you can use a formula like

SUM(IF [Contact Results] = "Call" Then 1 else 0 end)

If you always want the value to the count of Calls no matter what you're looking at, then you can use something like

{FIXED :SUM(IF [Contact Results]="Call" then 1 else 0 END)}

The 3 methods give the result below. I see you've used COUNTD, but you don't have any duplicate IDs.  If there are duplicate IDs then the methods above are too simple.  Maybe if you can explain the context of what you're trying to do, someone can give a more helpful answer.

2 of 2 people found this helpful
• 2. Re: Question to "IF" formula

Hi DS,

For the formula there text should be surrounded by single quotes to identify, so should be

[Contact results] = 'Call'

As for the full calculation there's a couple of ways to do this.

The most straightforward is to have the calculated field as

IF ([Contact results]) = 'Call' then [ID] end

and set the measure calculation in the shelf to CountD. If you did want to do it all in the calculated field you can have the formula as

COUNTD(IF ([Contact results]) = 'Call' then [ID] end)

Chris

2 of 2 people found this helpful
• 3. Re: Question to "IF" formula

Hi Dilyana,

You cannot mix aggregate & non-aggregate comparison in a if statement. The countd function here is an aggregation & hence cannot be used with a non-aggregate field contact result.

ATTR([Contact results]) = "Call" then countd [ID]

I am attaching the Tableau workbook for your reference. Refer to the field Count ID.

Cheers,

Rudranshu Praharaj

1 of 1 people found this helpful
• 4. Re: Question to "IF" formula

If ATTR([Contact results]) = "Call" then COUNTD([ID])

end

Mahfooj

2 of 2 people found this helpful
• 5. Re: Question to "IF" formula

HI guys, thank you so much!!!!

Best regards from Berlin

Dili