COUNTIFS (w/ an S) comes from where?
Number of records we know and can handle no problem.
Where two conditions are met is also no problem; but we don't use 'columns'.
So please expand your question. Thanks,
never mind; was able to achieve using filters. btw, i meant countifs from excel. what do you use instead of columns? im very new to tableau so i dont know the lingo.
In Tableau while we can produce a text table with 'columns', the ability to treat/affect columns individually is very limited. For instance, in Excel you can add conditional formatting to an individual column and the formatting will not affect other columns. This is very much NOT the case in Tableau. Yes there are some 'workarounds' but these are difficult to implement and maintain, and generally they are performance killers.
I mention all this because the sooner you move from Excel-think to Tableau-think the happier your Tableau experience will be.
PS: Welcome to the forums!
1 of 1 people found this helpful
I believe the answer you are looking for is "yes". You can write calculations like:
COUNT(IF [Dimension1]='ABC" AND [Dimension2]='1234' then [OrderNum] END) // Comparing two columns
or COUNTD(IF...same thing...)
or SUM(IF... same thing...)
I didn't realize this for many months of using Tableau, so I hope this will help you. I write COUNTD(IF...) calcs very often.
that looks like what i need. thank you!
Not a problem, these calcs can be huge time savers! Make sure to mark your question answered if you have what you need; this helps keep the forum "clean". Cheers.