Count & CountD functions in Tableau

[@dezzzz_tiny]

simple and descriptive, thanks so much!

[@michellexg]

thanks I was able to finish a class assignment thanks to you

[@TableauTim]

Happy to have helped! 👍🏾

[@miz2975]

how can I use count distinct in a case statement ? it gave me "Cannot mix aggregate and non-aggregate comparisons or results in 'CASE' expressions" error

[@davidjackson7675]

Thanks, that was exactly what I was looking for.

[@aapbeete9761]

good one bro.. I got, what I was searching for..

[@Oluwagbeoyemiga]

@Tableau Tim , What if I want to add two COUNT() categories? How do I go about it?

[@TableauTim]

Two separate calculations. This is the same in any database or analytical tool. Each computation is a separate calculation. Feel free to write an example if I’m not understanding your question correctly

[@Oluwagbeoyemiga]

@@TableauTim Thanks.

[@yashkaran1]

To the point video. Thanks a lot :).

[@rajashekarn2000]

Nice video as usual..Please make a video on LoDs with use cases...

[@TableauTim]

LOD function are in the list will get there soon.

[@cococnk388]

Thanks for the tuto… Can you do Count where product item is equal to a certain value in the column ?

[@rajatjain8348]

very nice videos tim!! :)

[@rick3465]

How to countif in tableau?

[@suliptapanda5362]

Can you help, how to calculate sum of COUNTD(Client ID) ??

[@TableauTim]

You cant do Sum of copuntd because itsa lready an aggregation. I assume you just want to count the number of unique clients. COUNTD(ClientID) will do just that,.

[@ravirajgokhale2466]

I am stuck and need help. I need to calculate active records per month until the enddate given as parameter/filter. Can anyone help?

[@moneysmartdude]

Hello, I love your video on tableau. Can you tell me how I can find duplicate values in two columns or under the row section in tableau? I have a large data from two columns and they contain duplicate values/figures. Do I have to create a calculated field to find the duplicates and if so, kindly tell me the formula or recommend a solution to my question. Thanks.

[@TableauTim]

I think Jellyman Education just did a video on this on his channel. Check it out. kzbin.info/www/bejne/n2KVpJ6GrL-nn7c

[@TheDragonaf1]

Wait? if thats countD. But how would you count if one Colum contains 2 sets? e.g. say in the "Sold from" Colum you have "online" and "in person" and on a bar chart you want to show the number of all sales vs the number of online sales on the same dual axis: use in the column: "sold from", then Filter "online", then right click and press count(sold from). This gives you the number of "online" sales. And on the same axis you want to also put the number of all sales, but the filer is still active from the last point and can't separate the two? i.e Colum: Count(all sales) Count(online) rows: shop (order descending on all sales) I've also tried making sets of each but you cant use the count function on a set

[@TableauTim]

have you got a smaple workbook you can link me to or maybe a screenshot? Im not sure i understand your question clearly

[@TheDragonaf1]

@@TableauTim sure. One moment. Also great videos! Finally someone with the correct use of language whom is explaining concepts to this software.

[@TheDragonaf1]

@@TableauTim I've put it on stack exchange as i can't figure out how to send you something here "Tableau can you make a dual axis graph using a count on a set?"

[@TableauTim]

@@TheDragonaf1 yuo got a url ?

[@TheDragonaf1]

@@TableauTim see if you can see the link.

[@louieboi7956]

Why would my count of a rank not show in my grand totals? 😵‍💫

[@TableauTim]

Grand total uses a special aggregation. Count of rank is already an aggregation. What you trying to achieve?

[@elizavetapudim9677]

Nice tutorial, but honestly, it will be better to show the difference while counting OrderId per category. It's a bit weird to count sub-categories when you use them in rows.

[@TableauTim]

Ah, sorry you don’t agree with my instruction here. Always worth considering the whole context of the video. KZbin doesn’t let you re upload videos so this won’t be anything I can change. Applogies

[@tag_of_frank]

Plot count of ID and aggregate by date, it won't show zeros. ZN function does not help. Tableau is insane.

[@TableauTim]

I think the issue here is the aggregation. You able to share a screen shot via imgur image sharing service and post the url here?