#Tableau
Вставка
- Опубліковано 23 лип 2024
- Using variance as a measure in bar charts helps you:
1. Add context - You can answer the question “compared to what?”
2. Make decisions - You can answer the question "what should we do next?"
3. Alert you to areas that need focus
In this video, I show you 10 ways to add variance to bar charts.
0:48 Variance to Prior Year Sales
2:14 Side by Side bar chart
3:15 Bar in Bar chart
4:32 Indicator for decrease in variance
6:07 Deviation/variance/difference between two measures
6:59 Year over year variance by month bar chart
7:36 Floating bar chart (Gantt bar chart)
8:17 Bullet graph
8:56 Sparkbars / spark bars / sparklines as bars
10:02 Population pyramid
Resources:
1. Workbook - www.vizwiz.com/2022/08/varian...
2. World Population Data - 1drv.ms/x/s!AhZVJtXF2-tD0mIH4...
Editing by: Javier Cristóbal Gutiérrez via upwork.com / javicristobal - Наука та технологія
Thanks tou so much! The way you have improved your videos is awesome! I really support your work, I am improving my skills because of you. Thank you for posting this.
Thank you. That means a lot. I've been putting in a lot of work to make the videos better.
ive seen a lot of tableau videos by others and this video format is so much easier to follow along with and learn
That’s great to hear. Thanks!
the red dot indicator is my favourite! thanks for sharing
My pleasure!
Love the "new" video style, Andy! Your profound knowledge of Tableau shines much more than with text.
Wow, thanks! That's very kind. It helps that I hired an editor this time. :-)
Thank you, Andy. That was very useful. Thank you once again for the HD.
Great Video. Thank you
You are welcome!
Love the new video style.
Yay, thank you!
I'm now a fan! You are really good at what you do.
I'll make sure to study your videos!
Cheers! And more success to your content.
Thank you Juan. It’s comments like that that keep me going. 👍🏻
I’m a newbie to tableau visual analytics world. This is awesome thank you!
My pleasure!
Thanks a lot! Really.
My pleasure.
video production techniques is ramping up I see Andy!
Indeed, with the help of an editor (in the description). He’s amazing. And it saves me so much time.
@@vizwiz I think it was well worth the investment then :D Vids are looking sharp
thanks Andy! I learned a lot about displaying variance from this video. could you post a similar tut on creating panel and grid plots, ones that include some kind of time series display at the individual grid level would be awesome. thanks.
How about this?
How to Create a Trellis Chart in Seven Steps
ua-cam.com/video/6_oMj9sKILQ/v-deo.html
@@vizwiz thanks Andy!
thanks for the tips Andy, i have a question about waterfall chart for variance, im not sure if its possible in Tableau,.....If you have 2021 YTD sales=100 on the left, 2022 YTD Sales=150 on the right, in between are the variance elements (lets say A, B, C, they are all separate calculations)， so from 2021 to 2022, that 50 variance is caused by A B C, so 2021 sales, A,B, C and finally 2022 sales, in total 5 measures. This is easy to plot in a table from left to right, but is it possible to show it as a waterfall in tableau ? funny thing is its quite easy to make in Excel
It's quite hard for me to understand the scenario you're trying to explain.
This is one of the best tips compiled in one video. Thank you very much!
Is it possible for us to get a copy of the workbook? It says under resources but it doesn’t look like it is there.
Thank you!! Here’s another video with lots of tips packed into one video.
Tableau Zen Master Tips & Tricks - Charts Edition
ua-cam.com/video/S5QN-fK2-wU/v-deo.html
Thank you very much!
Thanks Andy! I love the population pyramid. My only concern is that the female population now displays in negative form in the tooltip. Any suggestions regarding how to display it as positive?
You can put the original female population field on the tooltip.
Hi Andy, I'm a new user of Tableau and have been watching your videos for the last couple of weeks - they are very educative and informative. Thanks a lot for all your work! I had a question though, I'm struggling to under why in the latest year's sales calc you are multiplying the max year by sales. Thanks
I’m converting the Boolean that compares each year to the max year to a 1 or a 0 with the INT function. I then multiply that by sales. So I get sales for the max year and 0 for the other years.
That makes sense - Thanks a lot! This is a great trick to avoid writing an IF ELSE statement.
Is there a quick way to add the variance to mark labels? Your video production has gotten much better!
Drag the variance field onto the text shelf.
@@vizwiz Thanks I tried that but is not showing the correct variance value for the bar chart you did at 2:09. Is working for the bar chart with the two years next to each other.
Favorite choice for comparing 3 measures: Current year actuals vs. last year actuals and current year actuals vs. current year plan? There has to be something more slick than my current method of using 3 bars!
Are you asking how to do that? :-)
@@vizwiz asking your opinion on the visualization (and yes, how to do that if it’s not self-explanatory!)
I’d go with one bar chart with two reference lines (that are different colors). The bar length would be current year actual. The reference lines would be (1) last year actuals and (2) current year plan. That way you can also see how last year actually compare to this year’s plan.
I’ll create a short video.
@@wendyware3064 video coming next week. I've come up with 13 ways to visualize these 3 measures.
Hi , I'd like to understand the calc at 1:02 It's basically Int(True) * [sales]
when broken down ---> 3,379 * [sales]
How come we get the sales of that year ?
The LOD in that calculation determines if you're in the latest year. Tableau returns a boolean (T/F), which when you wrap in an integer is converted to 1 or 0. So if it's true, then you get 1 and then multiply it by sales. At the row level, if the order date is in the current year, you get the sales, otherwise you get 0. Does that help?
@@vizwiz Absolutely. Thanks . This is new to me.
I'd have used ---> if (YEAR([Order Date])={MAX(YEAR([Order Date]))}) then [Sales] END
I just learned a new way.
Hello sir this vides is great to learn more but I have a question
category/sub-category into column and sales in row then Avg line should be pane wise and define as
below Avg it should be in Red color and above Avg it should be in Green color how we can achieved
What’s the question?
Hi Andy.. Could pls make a video on how to bifurcate a quarter into 13 week dynamically
Like if we choose any quarter it should show 13 weeks
Like a drill down? As a bar chart?
@@vizwiz as a bar chart if I choose any quarter it should show 13 bars named as week 1 week 2...week 13
Yes. You can do that with either a parameter action or set action. It’s the same as any other drill down.
No wonder many Python Analysts pretend not to like Tableau: that's quite challenging to produce in Python 🙂
😂