Fixed Level of Detail Calculation: Tableau Functions

  Рет қаралды 53,574

Tableau Tim

Tableau Tim

Күн бұрын

Пікірлер: 70
@jsx0328
@jsx0328 Жыл бұрын
Thanks for including ACTUAL EXAMPLES of how it's used. Love this.
@ducjoshnguyen
@ducjoshnguyen 3 жыл бұрын
I came for LOD knowledge and left with much more. Thank you so much Tim!
@fishkenorian
@fishkenorian Жыл бұрын
thanks a lot! Actually I used tableau couple of years ago on a daily basis at work and now decided to go back to it, and your videos are on very high level and add a lot even to a daily user in the past :))
@christopherstaines-md1cy
@christopherstaines-md1cy 2 жыл бұрын
I have watch other videos explaining fixed LOD and yours has the best explanation. Thank you
@chao-chienchen4393
@chao-chienchen4393 10 ай бұрын
Found this gem now, still appreciated for your gold content
@deeengland4216
@deeengland4216 Жыл бұрын
Thank Tim! The context you provide is SUPER helpful. I appreciate it.
@oliviaml1243
@oliviaml1243 3 жыл бұрын
Thank you, Tim! I'm aiming to take the the Tableau Specialist Desktop Certification exam by May and these videos are a great help. I appreciate the clear editing, comments, and easy follow through. :)
@Neutrino-xw6jl
@Neutrino-xw6jl 2 жыл бұрын
How did you do?
@hetilemabunda9705
@hetilemabunda9705 Жыл бұрын
I need to watch this at least 3 more times before I really get it but this is such a great explanation!
@jasone831
@jasone831 3 жыл бұрын
This the best explanation of LOD out there. I wish I had been able to watch this a year ago when I was trying to learn this...
@shawnhumble5685
@shawnhumble5685 7 ай бұрын
Really nice description and clear delivery.
@AllaboutExperienceReshh
@AllaboutExperienceReshh 10 ай бұрын
Thanks for detailed explanation & sources for going indepth analysis of topics
@ankitashinde1403
@ankitashinde1403 Жыл бұрын
Thank you so much for the great explanation; it's very helpful and elaborative.
@joaquinhui2066
@joaquinhui2066 2 жыл бұрын
You are a super clear and structured teacher! Thanks!
@sdnc99new38
@sdnc99new38 3 жыл бұрын
You are very clear in your explanations. Subscribe button smashed!
@GB-hc9kr
@GB-hc9kr 2 жыл бұрын
Your channel is great. Thank you so much. You are a wonderful instructor.
@miganooshharoutunians9735
@miganooshharoutunians9735 2 жыл бұрын
Truly grateful for your thorough explanations, and thoughtful presentations. You are on my KZbin Dial🙂 for Tableau questions and trainings.
@TamerAgha.
@TamerAgha. 3 жыл бұрын
That was amazingly good! Tim, mate you are the best!
@deepak39754
@deepak39754 3 жыл бұрын
Thank you Tim for the amazing explanation of concepts ..
@joshdee7639
@joshdee7639 2 жыл бұрын
Great video man. Something about the way you and SqlBelle do videos that makes it easier to grasp.
@aapbeete9761
@aapbeete9761 3 жыл бұрын
you r doing a great job Tim..! Keep em coming!
@desisto007
@desisto007 10 ай бұрын
Clear explanation, thank you so much!
@TableauTim
@TableauTim 9 ай бұрын
You're very welcome!
@rajashekarn2000
@rajashekarn2000 3 жыл бұрын
Most awaited video...thank you Tim !
@danieldeleon609
@danieldeleon609 Жыл бұрын
Definetely subscribed. Very detailed and clear explanations
@tz1938
@tz1938 3 жыл бұрын
Awesome video! Thank you Tim!!
@tokio2t
@tokio2t 3 жыл бұрын
Really appreciate your content and how you present information/concepts in an easy to understand way. Keep up the fine work!
@cesargonzalez4935
@cesargonzalez4935 3 жыл бұрын
Thanks you man, this topic is good to keep understanding, always.
@y-lion
@y-lion 2 жыл бұрын
Thank you so much, Tim!
@rajatjain8348
@rajatjain8348 3 жыл бұрын
Superb Explanation!!
@nafiulhaque5585
@nafiulhaque5585 3 жыл бұрын
Very good explanation. Thank you.
@beabipro8544
@beabipro8544 2 жыл бұрын
Love your videos very informative.
@vsagar4b38
@vsagar4b38 3 жыл бұрын
Excellent Videos
@tracyzarna7208
@tracyzarna7208 3 жыл бұрын
You are amazing! Thank you so much!
@GaitherStephens
@GaitherStephens Жыл бұрын
Great video, and I hope you got to watch that Line of Duty episode! 🤣🤣🤣
@AliciaMarkoe
@AliciaMarkoe 3 жыл бұрын
Thank you 🦋
@meetalipandey8073
@meetalipandey8073 3 жыл бұрын
Thank for sharing..!!
@deeswift-z1h
@deeswift-z1h 5 ай бұрын
Hi have you used the conditional formatting of tables in different situations. Can you come out and tell me the ways
@bitstop2003
@bitstop2003 2 жыл бұрын
Google Datastudio doesnt have LEVEL of Detail calculation, nor Rank() function. Thanks for this video
@ArjunSingh-rn3wh
@ArjunSingh-rn3wh 3 жыл бұрын
Thank you for such informative videos. Can you please suggest from where we can practice the questions for LOD and various others?
@andrewvilliers4767
@andrewvilliers4767 Жыл бұрын
At 18:20 I'm doing the same thing except noticing that some entries have a count of 2 (appreciate this is a year after this was first posted). I'm seeing that order ID CA-2019-123625 has two rows of product name Acco Glide Clips and two rows of Hand-Finished Solid Wood Document Frame. Each have different quantities. I can only guess it's how the data has been collected (maybe the customer added 5 Acco Glide Clips and then realised they wanted 7 in total. Instead of updating the existing one to a quantity of 7, they added another Acco Glide Clips separately to the same order with a quantity of 2).
@TableauTim
@TableauTim Жыл бұрын
Different data. The data sets across different versions of Tableau are slightly different they started changing them after this video was made. I didn't know this at the time but something to be aware of.
@mohammedaskar4268
@mohammedaskar4268 7 ай бұрын
thanks
@derekl2882
@derekl2882 10 ай бұрын
I have values for Jan-Dec. I want to identify the month value with the max, so I feel like I need to FIX my date parameter to ignore LOD (so it evaluates each month against the year range) but I cannot get this work. Either I am making this harder than it needs to be or Tableau is. How do I calculate the month with the highest total in that year? I.e. in Superstore data which month in the current year has the highest monthly total?
@rameshamoily5524
@rameshamoily5524 2 жыл бұрын
Hi Tim, this great content and i am new to tableau Do you have any videos on "calculate difference between two rows ". this is mainly required to prepare Financial statements in tableau.
@TableauTim
@TableauTim 2 жыл бұрын
Not related to this video but you want to look for 'tableau quick table calculations' I touch on this here kzbin.info/www/bejne/bnrchIChrZmhaqs but you can just use a quick table calculation to do the difference for you see this guide: help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations_quick.htm
@kondrusharathchandra
@kondrusharathchandra Жыл бұрын
One quick question: How do you highlight the text with arrows and rectangle boxes. What is the tool name
@TableauTim
@TableauTim Жыл бұрын
It’s in the description. kzbin.info/www/bejne/eKuxlnWXe9-IjKc
@ВикторияТелятникова-т4н
@ВикторияТелятникова-т4н 3 жыл бұрын
Hello! Can you tell how to show only one (last) value of "percent difference" result (quick table calculation) when we use data filter with single value. When we put data filter, it also filters the whole table and leave only one row. So, Tableau can't calculate the percent difference for only one row. The aim is to create dashboard where user will choose one date and the value of percent difference changes. Thanks!
@TableauTim
@TableauTim 3 жыл бұрын
Tableau can do that calculation but im not clear i understand your example. Are you asking for the percent difference from a specific date?
@AliTwaij
@AliTwaij 4 ай бұрын
nice
@jiachenchristianxu965
@jiachenchristianxu965 2 жыл бұрын
Hi Tim, I have a quick question-I have a calculation field which is total amount/total number of account and there is a filter A. Right now when I change the filter A both the numerator and denominator would change value. My goal is to not let the filter apply on the denominator and let it only apply on the numerator. Is there any way to do this? Any insights would be appreciated!
@TableauTim
@TableauTim 2 жыл бұрын
You’re on the video to fix that problem. Create an LOD at each level and the filters shouldn’t affect it. Please watch the video I recommend called order of operations.
@devanshbhardwaj5955
@devanshbhardwaj5955 3 жыл бұрын
hi man can you help me create a rolling cohort retention curve, also the tricky part is I want a dashboard where we can change the cohort from weekly to monthly and then roll that cohort weekly.
@TableauTim
@TableauTim 3 жыл бұрын
What would you expect to happen if you were showing the monthly view but rolling up the weekly cohorts, the moving calculation would be average the weekly scores which is technically not quite right .
@Sila23Stars
@Sila23Stars 11 ай бұрын
How does this work with dates and using tableau server
@TableauTim
@TableauTim 11 ай бұрын
It works everywhere. Server has no impact on this feature. It works exactly as you’d expect with dates. Make sure you fix at the right level of dates for example to find the first date a customer bought an item, you say fixed at the customer column, min date.
@Sila23Stars
@Sila23Stars 11 ай бұрын
@@TableauTim thank you. This only works in obtain only dates, how would it work if am trying to obtain not the second date but a user who previously scanned a specific item ID not the current user who scanned that same item ID?
@TableauTim
@TableauTim 11 ай бұрын
Just adapt the calculation and fix it to the item Id
@kanikasuneja7777
@kanikasuneja7777 10 ай бұрын
What I liked-simplicity, what I didn't like-you never showed how finally context filters helped us get the right answer
@TableauTim
@TableauTim 9 ай бұрын
I can’t recall the moment but apologies. Try it. See what happens. For context I don’t script my videos so occasionally I do forget small things I said I would do. If I scripted them it would take far longer, most of my videos about 95% are just me hitting record with a dataset I grabbed 20 minutes prior and sharing what I know. For more structure you’d need a course on udemy or something paid. This is free and on KZbin.
@kanikasuneja7777
@kanikasuneja7777 9 ай бұрын
@@TableauTim Thanks Tim...even if it's free you are really being so helpful to people like us who can't afford fancy expensive courses just to be able to learn a skill and grab a job obviously because we're jobless at that moment. So, thanks...please take the feedback positively and keep working for us.
@TableauTim
@TableauTim 9 ай бұрын
@@kanikasuneja7777 Thank you for that note! Appreciate the thought and time you took to reply. I can always do better and we'll get there eventually.
@CameronWilson-s4j
@CameronWilson-s4j Жыл бұрын
you put all other Tableau videos on KZbin to shame.
@nathanthreeleaf4534
@nathanthreeleaf4534 Жыл бұрын
Great explanation...I still don't get it...
@TableauTim
@TableauTim Жыл бұрын
Which part? the easiets way to thnk of it is that its like making a calculation and remembering the values to use later on. You make a calculation at the level you need and then tableau remembers the values even if you do another calculation on the same sheet.
@ScissorN
@ScissorN 5 ай бұрын
😵‍💫😵‍💫😵‍💫
@MrHijazi323
@MrHijazi323 4 ай бұрын
no need for music brother, it's too loud. Thank you though
@TableauTim
@TableauTim 4 ай бұрын
hey i was learning to edit back then :D sorry
Include Level of Detail Calculation: Tableau Functions
25:30
Tableau Tim
Рет қаралды 15 М.
What is ATTR (...) aka Attribute Function in Tableau?
20:26
Tableau Tim
Рет қаралды 24 М.
Quando eu quero Sushi (sem desperdiçar) 🍣
00:26
Los Wagners
Рет қаралды 12 МЛН
“Don’t stop the chances.”
00:44
ISSEI / いっせい
Рет қаралды 10 МЛН
黑天使只对C罗有感觉#short #angel #clown
00:39
Super Beauty team
Рет қаралды 31 МЛН
Table Calculations in Tableau: Everything You Need to Know
24:54
Andy Kriebel
Рет қаралды 112 М.
FIXED Level of Detail (LOD) Expressions | #Tableau Course #97
9:45
Data with Baraa
Рет қаралды 8 М.
What is the Lookup function in Tableau? Tableau Functions
30:34
Tableau Tim
Рет қаралды 22 М.
Exclude Level of Detail Calculation: Tableau Functions
24:56
Tableau Tim
Рет қаралды 9 М.
How to use Fixed Level of Detail (LOD) Calculations in Tableau Desktop
12:13
INCLUDE Level of Detail (LOD) Expressions | #Tableau Course #99
8:17
Data with Baraa
Рет қаралды 5 М.
What is the Window function in Tableau? Part1  Tableau Functions
31:45
Quando eu quero Sushi (sem desperdiçar) 🍣
00:26
Los Wagners
Рет қаралды 12 МЛН