Count & CountD functions in Tableau
These both count the number of items in a specific group, however, COUNT counts all items and COUNTD counts only unique items in the same group. -
#tableau #salesforce #analytics Share feedback and Suggestions: tableautim.canny.io/suggestions -
-
Join this channel to get access to perks:
/ @tableautim ----------
(C) 2023 TN-Media LTD. No re-use, unauthorized use, or redistribution, of this video without prior permission.
Пікірлер: 31
Thanks, that was exactly what I was looking for.
thanks I was able to finish a class assignment thanks to you
@TableauTim
2 жыл бұрын
Happy to have helped! 👍🏾
To the point video. Thanks a lot :).
good one bro.. I got, what I was searching for..
very nice videos tim!! :)
Nice video as usual..Please make a video on LoDs with use cases...
@TableauTim
3 жыл бұрын
LOD function are in the list will get there soon.
Thanks for the tuto… Can you do Count where product item is equal to a certain value in the column ?
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
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
3 жыл бұрын
I think Jellyman Education just did a video on this on his channel. Check it out. kzread.info/dash/bejne/m2Vm1c2Jp73ambg.html
How to countif in tableau?
Can you help, how to calculate sum of COUNTD(Client ID) ??
@TableauTim
3 жыл бұрын
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,.
@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
11 ай бұрын
@@TableauTim Thanks.
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
2 жыл бұрын
Ah, sorry you don’t agree with my instruction here. Always worth considering the whole context of the video. KZread doesn’t let you re upload videos so this won’t be anything I can change. Applogies
I am stuck and need help. I need to calculate active records per month until the enddate given as parameter/filter. Can anyone help?
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
2 жыл бұрын
have you got a smaple workbook you can link me to or maybe a screenshot? Im not sure i understand your question clearly
@TheDragonaf1
2 жыл бұрын
@@TableauTim sure. One moment. Also great videos! Finally someone with the correct use of language whom is explaining concepts to this software.
@TheDragonaf1
2 жыл бұрын
@@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
2 жыл бұрын
@@TheDragonaf1 yuo got a url ?
@TheDragonaf1
2 жыл бұрын
@@TableauTim see if you can see the link.
Why would my count of a rank not show in my grand totals? 😵💫
@TableauTim
2 жыл бұрын
Grand total uses a special aggregation. Count of rank is already an aggregation. What you trying to achieve?
Plot count of ID and aggregate by date, it won't show zeros. ZN function does not help. Tableau is insane.
@TableauTim
2 жыл бұрын
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?