What is the Lookup function in Tableau? Tableau Functions

[@I_Follow_Jesus]

You sir, are awesome. I’ve been using Tableau professionally for about 6 months as a data analyst. Your videos are very informative

[@TableauTim]

Great to hear and happy to help. Let us know if you don't find something

[@whalemurugun]

Great video Tim.!!

[@AliTwaij]

Really useful thankyou Tim.

[@priyashome887]

Thanks Tim! Learned and learning a lot from you.

[@TableauTim]

Glad to hear it!

[@MatthewMelville]

Thanks Tim, superb explanation!

[@CameronWilson-s4j]

You make awesome videos!

[@AliciaMarkoe]

Awesome! Thank you 🦋

[@TableauTim]

Any time!

[@priyashome887]

Hi Tim, Please reduce the size of your image, it will help us to view the background visuals in clear.

[@TableauTim]

This is quite an old video. Check out my more recent videos and I don't think it gets in the way of too much content.

[@shivkumarpatel7940]

love from india ❤

[@ravinduabeygunasekara833]

Bro I am enjoying your videos and learning a lot! Your videos are crystal clear, what is the camera you use?

[@TableauTim]

It’s all in the description of the videos but I use an Sony a6600 as a webcam today but I’m this video might have been my Phone through an app called CAMO,

[@vish8191]

Superb site !

[@svitlanaalfimenkova6367]

thank you!!!

[@TableauTim]

You're welcome!

[@manikumarjalasutram2479]

Hey Tim, In Mac We can use Option button to drag the date to get the selection screen right?..Have been learning a lot from your videos ❤..thank you for all the hard work!

[@TableauTim]

You can indeed. when i made this video i had switched form my windows PC and annoyingly forgot it.

[@mayowatayo2848]

Hello Tim, i find your videos very helpful. I am new to Tableau and i would like to know if there is a function to find out whether there are any increased prices from products over a period of time?

[@TableauTim]

No such function that's more of an analytical calculation or LOD (Level of detail calculations). Sits better as part fo the data pipeline.

[@rajeshmedisetti6575]

Hi Tim, following you from past 1 year, very informative and helpful. I've query on using dimension of text in look up. Eg: lookup(country name,0). But we can't aggregate country field right. What is the best solution for this? Thanks in advance

[@ecehatipoglu209]

I love you

[@adiabedeen3133]

Thanks man

[@stoneage8810]

is this doing similar thing as DATEADD ? just lookup needs very specific context

[@saurabhbanerjee6368]

Is there’s a way to use this search all the data from table and find out a matching column

[@TableauTim]

No it cant search for columns. it searches for values in tables.

[@snakeboy2904]

Question. Isn't in this example taking the future value from the offset not the past (ie taking the value for November2020 and placing it in November 2019)?

[@TableauTim]

have you got a time stamp? I switched the direction of the lookup so you might be right and i might have made a mistake.

[@snakeboy2904]

@@TableauTim 24.59 offset 6 and 25.56 offset 12. If you wanted to lookup a future value (YOY comparison) you would do negative number right? I guess its up to what line you are looking at when comparing past and future(sales line vs lookup demo)

[@snakeboy2904]

I Guess a better way I could explain is that if the offset is a positive number it will bring up a value from the past and compare it with the date you are looking at. If the offset number is a negative, then it will take a future value and compare it to the date you are looking at.

[@viswanathreddy4970]

Hai gundu boss

[@ajitkumarsahoo8859]

Hi Tim, I have a question. If there are working hours and planned hours of 2021 and 2022. Remaining hours = planned hours - working hours. Then How to add total remaining hours of 2021 to every months(2022) planned hours evenly through lookup

[@TableauTim]

Dont think this question is related to lookups. It sounds like you just described the calculation yourself. If year = 2022 then planned hours + (remaining hours of 2021 / 12) else null end. I wouldnt use a lookup this is just a table calculation.

[@ajitkumarsahoo8859]

@@TableauTim I want to add the total remaining working hr of a yr(2021) with next yr (2022)evenly distributed with all remaining hr of each month of 2022 and when January 2022 completes if there is some remaining hour left then it should be evenly distribut to upcoming months and so on.

[@aliahmed1250]

@@ajitkumarsahoo8859 so its been an year, you must have found the solution, whats that

[@tableaututorialstips71]

Thanks for sharing this Tim:),I have a question if we have nulls i need to display net available value how can we do this ?

[@TableauTim]

check out my video on the ZN function kzbin.info/www/bejne/Y5bXeK18aZhmpJo you can use that to replace nulls with zeros and then from there calculate your values

[@jamesmorell1758]

I am completely confused. How do you know where the 0 is in the parenthetical in relation to the view. And if you were to use negative numbers, such as (-1,0) how do you know where that starts? How do you know when to use positive and negative numbers?

[@TableauTim]

its always relative tot he starting point of the calculation so a running total always starts from the first record of the data set. A 2 week moving average will start from 2 weeks prior to the current one if you only look back 2 weeks and not 1 week back and 1 week ahead. Just depends on the question your asking.

[@powerbis.1794]

DAAAAAMN WHATSUP YOYO

[@TableauTim]

Hey 👋🏾

[@powerbis.1794]

@@TableauTim calmed cool relaxing explanations)

[@MarkSchild-f8y]

good but cut the length of the video in half

[@TableauTim]

30% of people are still watching at the half way mark so i think its good to keep this long.

[@satyamace]

Awesome. also, your face always comes in between your explanations in the background. Maybe you can place it on the top right.

[@TableauTim]

Nah I like it where it is after 490 videos I can confirm it’s in the least annoying place.

[@kyle.smyle.]

Felt like half of this video taught us which way up is and which way down is. Lots of talking with all due respect

[@TableauTim]

Hopefully you found it useful. It’s one of my earlier videos when I was still getting the hang of things but as always if if not helping value the feedback and there’s always other creators on KZbin or maybe a paid course with more structure and editing. Thanks for stopping by. ✌🏾

[@humeramadni7652]

Losing the benefit of understanding what you wnt to deliver because of excessive explaination. Please keep it short.

[@TableauTim]

Maybe this video isn’t for you. Sorry it didn’t help. Bear in mind we’re all just punters g our time to help others.