If it helps, I am trying to do this
SELECT a.taskID, a.tweet, a.C, b.CC
SELECT taskID, tweet, COUNT( * ) C
WHERE Category = 'Not Relevant / Skip'
GROUP BY TaskID
SELECT taskID, tweet, COUNT( * ) CC
GROUP BY taskID
WHERE a.taskID = b.taskID
AND a.C = b.CC
How many categories are their? Is this likely to change? Is it where the ID has 2 or more catehories?
Can you attach an example Tableau workbook?
There are only 7 categories. However I have 600,000++ task ID.
However most taskID has multiple category into them. I want to find which ID has only one category and the count of that.
Attached is a workbook.
Thanks a lot for looking into this.
testTableauCat.twbx 15.5 KB
I think the best option here is to create a count of unique category values per ID using a calculated field COUNTD([Category]). This should do the trick
I've attached an example workbook showing the number of unique categories per ID.
testTableauCat.twbx 18.6 KB
Although I am looking for all entries of that category, but your file gave me ideas how to solve it.
I think you've got this, but another way is to do something like:
SUM(IIF([Category] = 'Not Relevant / Skip',1,0))>0 AND SUM(IIF([Category] = 'Relevant but Other',1,0))>0
If you have this at TaskID level, it will be True for those TaskIDs that contain both 'Not Relevant / Skip' and 'Relevant but Other'.