Video

How would you define the color steps based on a calculated field target instead of defining the start/center and end in the UI? If sales target is 200, actual sales is 100 or less.... then it shows red. If its 101 to 199, it shows yellow, if its 200+ it shows green. If profit target is 120, actual profit is 40 or less.... then it shows red. If its 41 to 119, it shows yellow, if its 120+ it shows green. The solution described seems would only work with fixed ranges of the data.

Hats Off for your Explanation sir, All your vides are good. Sir I have little doubt this WINDOW_MIN( IF not ISNULL(SUM([Sales])) then INDEX() END)-INDEX() this gives first row value always if am not wrong but as percentage difference formula i.e. (current value - previous value)/previous value*100 .at" Appliances " level we have 42,168,180 values here it is not taking as taught formula (180-168)/168*100 .it is behaving to take first row value i.e.(180-42)/42*100 this is not correct as formula if my understanding is wrong please correct me.

Absolutely clear and straight to the point ! Thanks a lot 🎉😊

Thank u it’s helpful

hi is there a new invite link for whatsapp?

but instead of click alt+click is working, how can we change it to click only

Thank you so much for this , but I am unable to follow, because I don't know what Action is or how it relates to my information. Could you please explain what Action is?" Thank you

Very useful video, most of the videos in youtube only have first part of video where we are able to select different date granularity, but the dynamic change of date format is missing. Thanks for adding that as well. Here's little modification in it(added Week and Quarter, and changed date format to show month as mmm) if [Date Level] = 'Year' then STR(YEAR([Complaint Contact Date])) elseif [Date Level] = 'Quarter' then 'Q' + str(QUARTER([Complaint Contact Date])) + ' ' + STR(YEAR([Complaint Contact Date])) elseif [Date Level]= 'Month' then left(DATENAME('month',[Complaint Contact Date]),3)+' '+ right(STR(YEAR([Complaint Contact Date])),2) elseif [Date Level] = 'Week' THEN STR(DAY(DATETRUNC('week', [Complaint Contact Date]))) + ' ' + LEFT(DATENAME('month', DATETRUNC('week', [Complaint Contact Date])), 3) + ' ' + RIGHT(STR(YEAR(DATETRUNC('week', [Complaint Contact Date]))), 2) elseif [Date Level] ='Day' then str(DAY([Complaint Contact Date])) + ' ' + left(datename('month',[Complaint Contact Date]),3) + ' ' + right(STR(YEAR([Complaint Contact Date])),2) END

A

HI Thanks for the video, and if we would like to see only latest year sales% (in above case 2021) how can we show that value with out filtering years.

How can i make a 12 rolling average but not static, i mean calculate for example for the current month the average sales of the previous 12 months including the current one?

Was Helpful...Thank You

Can we fill the color to Cell instead text color?

Thanks, this really helped

Muchas Gracias!

Thank you so much! I was going crazy trying to do that in my own.

Tq sir

Whatsap group link not working

Why isn't working by just clicking, except with ATL + Click?

Nice Video

There has to be another approach to this... this makes the data very ugly as it displays 'True' in the results/dashboard. Trying to get hide the 'True' value from the results is entire separate battle..

I guess you have made a bit confusing. This is very simple step and don't require so many actions filters.

Sorry to say but the explanation is so so messy. Nothing is shown clearly. He is just jumping from here and there without giving proper clarity of the approach.

Can we make this pytd and cytd using filters.

Thanks for your support

Great

Please, how can i join your Whatsapp group? I tried using the link in the discription but it has expired. Kindly assist with a current link. Thank you 🙏

chart is dynamic but the axis is not, like year shows 1/1/2020, month shows 1/1/2020, day shows the same thing just different spacing

I think simply we can use DATETRUNC('month',[Order Date])-1 right?

thanks for making a separate playlist based on dates!...Learned a lot from these videos...keep going!!

How to bring header on the top of the measure values. It's showing on the bottom

Is there a way where both sheets will be shown when none of the button is selected and then when say, segment button is selected, the segment sheet takes up the entire horizontal container?

What if I have 33 measures and I attempting to find the lowest value?

Hi, can u tell me, how to setting timezone in tableau pulic? Bcs my data update in desktop n public different, thx

How can we show all these measures side by side by providing the 'All' option in the parameter?

Quick, crisp and clean! Well explained!

Hii Pls do video on 1. How to find out list of customers who did not order particular product in last 6 months. 2. Who ordered particular product in last 6 months.

Perfectly Explained and very Helpful !! Thank you !!

A

THIS IS STATIC MAKE DYNAMIC ONE

Hello bro can you tell me , how to get no of new and old customers per month New customers means no order from last one year

How would you account for days that doesn't have data? For instance, I have a data set where on 9/18/22 there were no orders so that date does not exist on my data.

Hi, i need the same calculation but using year and month separate field, so my filter should be start year and date and end year and date. Can you please help me on that.

can we do it for different data sources ?

How can I get the bar one next to the other one rather than one over the other?

Is there a workaround for this method when using a aggregate calculated field? I've got a ratio field (% of tickets per customer) and am trying to create a calculated field for the 12-month rolling average

Is there a way to change the measures for row and the month to column? I tried to drag but the colors are gone

Hello, how can I create a column that shows the difference between current and previous month? thanks in advance

Dear @TableauTutor , How can I create a calculated field which displays the difference between current month sales and previous month sales? I've already tried zn([Current month salesl]-[Previous month sales])

Thanks so much for the video. How can we select year instead of specific date? Show months in selected year