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

Thanks Tim, superb explanation!

Great video Tim.!!

Thanks Tim! Learned and learning a lot from you.

@TableauTim

Жыл бұрын

Glad to hear it!

You make awesome videos!

Superb site !

Awesome! Thank you 🦋

@TableauTim

Жыл бұрын

Any time!

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

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,

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.

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.

love from india ❤

Thanks man

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.

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

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.

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.

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 kzread.info/dash/bejne/X5moqdx_ZJaZnps.html you can use that to replace nulls with zeros and then from there calculate your values

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.

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

I love you

Hai gundu boss

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.

DAAAAAMN WHATSUP YOYO

@TableauTim

Жыл бұрын

Hey 👋🏾

@powerbis.1794

Жыл бұрын

@@TableauTim calmed cool relaxing explanations)

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.

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