What is the Lookup function in Tableau? Tableau Functions

Подписаться 177 тыс.

Просмотров 20 тыс.

50% 1

#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.com/current/pro/...
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.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.

Опубликовано:

17 авг 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 48

@I_Follow_Jesus 2 года назад

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

@TableauTim 2 года назад

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

@MatthewMelville 2 года назад

Thanks Tim, superb explanation!

@whalemurugun Год назад

Great video Tim.!!

@priyashome887 Год назад

Thanks Tim! Learned and learning a lot from you.

@TableauTim Год назад

Glad to hear it!

@user-sn5py3vx9k Год назад

You make awesome videos!

@vish8191 2 года назад

Superb site !

@AliciaMarkoe Год назад

Awesome! Thank you 🦋

@TableauTim Год назад

Any time!

@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,

@adiabedeen3133 2 года назад

Thanks man

@shivkumarpatel7940 2 года назад

love from india ❤

@rajeshmedisetti6575 2 года назад

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

@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.

@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.

@manikumarjalasutram2479 8 месяцев назад

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 8 месяцев назад

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

@stoneage8810 2 года назад

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

@ajitkumarsahoo8859 2 года назад

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 2 года назад

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 2 года назад

@@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

@snakeboy2904 2 года назад

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 2 года назад

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 2 года назад

@@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 2 года назад

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.

@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.

@tableaututorialstips71 2 года назад

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 2 года назад

check out my video on the ZN function ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--etGzF433n8.html you can use that to replace nulls with zeros and then from there calculate your values

@jamesmorell1758 2 года назад

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 2 года назад

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.

@ecehatipoglu209 Год назад

I love you

@viswanathreddy4970 2 года назад

Hai gundu boss

@satyamace 8 месяцев назад

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

@TableauTim 8 месяцев назад

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

@user-mk7ed8ks7r Год назад

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.

@powerbis.1794 Год назад

DAAAAAMN WHATSUP YOYO

@TableauTim Год назад

Hey 👋🏾

@powerbis.1794 Год назад

@@TableauTim calmed cool relaxing explanations)

@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 RU-vid or maybe a paid course with more structure and editing. Thanks for stopping by. ✌🏾