Goal: For a dimension, count the distinct numbers of records if the string has "List Email", otherwise count all records.

I've tried:

IF CONTAINS(ATTR([Subject]), "List Email:")
then ((COUNTD([Subject])))
Else COUNT([Subject])
END

(That works only if the dimension is in the view)

and

CASE CONTAINS(ATTR([Subject]), "List Email:")
WHEN TRUE   then ATTR({ FIXED  [Subject] : COUNTD([Subject])})
ELSE ATTR({ FIXED  [Subject] : COUNT([Subject])})
END
 User Dec Jan Total 3 17 Thomas 1 9 John 2 8
Apr 9, 2018 in Tableau 17,183 views

## 1 answer to this question.

From the desired output it seems that you want to fix on [User] and MONTH([Date]) (vs fixing on [Subject] as in the code tried in the question).

This field will gives you the desired output. :

User Emails for Month:
{ FIXED [User], MONTH([Date]) :
COUNTD(IIF(CONTAINS([Subject],"List Email"),[Subject],NULL))
+
COUNT(IIF(NOT CONTAINS([Subject],"List Email"),[Subject],NULL))
}

For each User and Month, count distinct emails that contain List Email and add to that all emails that don't contain List Email.

But if all you need is the grand totals to be 3 for December and 16 for January (i.e., count distinct subject regardless of the user), then LOD calculation is not necessary:

# Emails:
COUNTD(IIF(CONTAINS([Subject],"List Email"),[Subject],NULL))
+
COUNT(IIF(NOT CONTAINS([Subject],"List Email"),[Subject],NULL))
• 1,560 points

## How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

## SQL query to count number of distinct products

Hi Preethi, Use below SQL query, SELECT CUST_ID, COUNT(DISTINCT ...READ MORE

## Dynamically set the value of a filter based on a parameter selection in use to swap sheets

Here's a simplified example of the calculated ...READ MORE

## How to calculate the percent of records within a group in tableau?

You can click the measure SUM(Number of Records) and ...READ MORE

## how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

## How can I count the aggregate function in Tableau

Create two calculated fields one for 100's ...READ MORE

## How to count occurrence of value and percentage of a subset in tableau public?

Although it sounds like a fairly easy ...READ MORE

## How to aggregate and count the occurrence of TRUE and FALSE?

Hi, you can do any of below ...READ MORE