What is the Lookup function in Tableau? Tableau Functions
ฝัง
- เผยแพร่เมื่อ 25 ส.ค. 2024
- #tableau The lookup function is a handy calculation you might use to compare today's metrics with previous months years or even custom offset periods. In this video, I show you how it works as we continue to cover functions.
Tableau Notes: help.tableau.c...
Returns the value of the expression in a target row, specified as a relative offset from the current row. Use FIRST() + n and LAST() - n as part of your offset definition for a target relative to the first/last rows in the partition. If offset is omitted, the row to compare to can be set on the field menu. This function returns NULL if the target row cannot be determined. Share feedback and Suggestions: tableautim.can... -
-
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.
You sir, are awesome. I’ve been using Tableau professionally for about 6 months as a data analyst. Your videos are very informative
Great to hear and happy to help. Let us know if you don't find something
Really useful thankyou Tim.
Great video Tim.!!
Thanks Tim! Learned and learning a lot from you.
Glad to hear it!
Thanks Tim, superb explanation!
Hi Tim, Please reduce the size of your image, it will help us to view the background visuals in clear.
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.
thank you!!!
You're welcome!
You make awesome videos!
Superb site !
Awesome! Thank you 🦋
Any time!
love from india ❤
Thanks man
Bro I am enjoying your videos and learning a lot! Your videos are crystal clear, what is the camera you use?
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,
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
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!
You can indeed. when i made this video i had switched form my windows PC and annoyingly forgot it.
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?
No such function that's more of an analytical calculation or LOD (Level of detail calculations). Sits better as part fo the data pipeline.
Is there’s a way to use this search all the data from table and find out a matching column
No it cant search for columns. it searches for values in tables.
is this doing similar thing as DATEADD ? just lookup needs very specific context
I love you
Hai gundu boss
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
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.
@@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.
@@ajitkumarsahoo8859 so its been an year, you must have found the solution, whats that
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?
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.
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)?
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.
@@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)
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.
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 ?
check out my video on the ZN function th-cam.com/video/-etGzF433n8/w-d-xo.html you can use that to replace nulls with zeros and then from there calculate your values
good but cut the length of the video in half
30% of people are still watching at the half way mark so i think its good to keep this long.
Awesome. also, your face always comes in between your explanations in the background. Maybe you can place it on the top right.
Nah I like it where it is after 490 videos I can confirm it’s in the least annoying place.
Felt like half of this video taught us which way up is and which way down is. Lots of talking with all due respect
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 TH-cam or maybe a paid course with more structure and editing. Thanks for stopping by. ✌🏾
DAAAAAMN WHATSUP YOYO
Hey 👋🏾
@@TableauTim calmed cool relaxing explanations)