#Tableau

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

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

50% 1

Calendar heatmaps are a great way to visualize time-series data over an entire calendar year. Individual days are shaded on a light-to-dark gradient based on a measure that has been added to the visualization.
In this tip, I going to show you, step-by-step, how to create a full year calendar heatmap in Tableau.
Creating a heatmap for a single month in Tableau is pretty straightforward. It gets a bit more complicated when you want to view an entire year at once.
You'll find all of the calculations you need in the workbook.
www.vizwiz.com/2022/11/calend...
Get the date file for scaffolding here -
bit.ly/Dates2019-2030
If you have any questions, please leave a comment.
==========
ABOUT THIS CHANNEL
This channel is dedicated to making you great at Tableau and introducing you to careers and influential people in data.
SUBSCRIBE
/ andykriebel
MORE TIPS & INTERVIEWS
www.vizwiz.com/
www.dualaxispodcast.com/
FOLLOW ME ON SOCIAL
Get updates or reach out to get updates on my social media profiles!
Twitter: / vizwizbi
LinkedIn: / andykriebel
Facebook: / vizwiz
Spotify: spoti.fi/3Sw5i5D
Apple Podcasts: apple.co/3yj7y89
Google Podcasts: bit.ly/3yiz0mq
Amazon Music: amzn.to/3yk27Wy
===============
MY EQUIPMENT
** Blue Yeti Microphone
amzn.to/3SjnjCX
** Endurax 66" Video Camera Tripod
amzn.to/3F4ogMy
** iPhone 13 (camera)
amzn.to/3VP01YA
** Neewer® 700W Professional Photography 24"x24"/60x60cm Softbox for Lighting
amzn.to/3VJLoGa
===============
CREATE GREAT RU-vid CONTENT
🎬 Part-Time RU-vidr Academy - Ali Abdall's 6-week live online course on becoming a part-time RU-vidr
ptya.samcart.com/referral/IKj...
📚 More great courses from Ali
ptya.samcart.com/referral/7he...
===============
DISCLAIMER
This video and description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. Proceeds go to producing content for this channel.

Наука

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

21 ноя 2022

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@premgct87 Год назад

What a timely video. Yesterday I was making a hourly heat map and was thinking it would be better if I had an easier way to create a daily heat map just like yours. Going to try this now.

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

Perfect! I love it when I find the exact video tutorial I am looking for. Thanks for putting this together!

@paulwyatt8523 Год назад

Thank you Andy. This video took me the longest to understand and be able to implement all of the techniques you have used. Of note are the ‘Month name’ and the ‘empty dates’ - absolute genius. I’m now able to use the FULL YEAR calendar with a MONTH widget to really powerful effect. 😊

@vizwiz Год назад

Amazing! I’m glad it was helpful.

@nowfeleusuf2294 Год назад

This was "Boss''! Absolutely mind blowing..

@TemporallyYours 4 месяца назад

Great tutorial, thanks. Two things, 1) For anyone else trying to do this with a count of the rows of your data/table based on appointments/sessions/visits dates, you may run into the issue where days with 0 still show as having 1 count as it is counting the day from the scaffolding data. You cannot just modify the calculated statement by subtracting by 1 because days that DO have at least 1 count are counted accurately (ie it does not add 1 from the scaffolding sheet). To get around this I did two things (not sure which one worked or if you need to do both, so listing them both here): first I changed the way the data was connected from an actual join to just a relationship (many to many), and second I changed the calculated statement to create the white squares to as follows: IF COUNT([TableName]) = 0 THEN -1 ELSE COUNT([TableName]) END 2) As others have mentioned, this viz does not work well with any filters applied. Has anyone found a good workaround for this?

@vpnath75 Год назад

Thanks, this is very creative! I always get good ideas from your videos. Much appreciated!

@vizwiz Год назад

👍🏻👍🏻

@lte23401 Год назад

This is so amazing. Thanks for uploading, very helpful.

@vizwiz Год назад

You're very welcome!

@melchornegrete3431 Год назад

Hello Andy, what a nice videos!. They are so easy to understand, congratulations.

@vizwiz Год назад

Thank you!

@imsajiv Год назад

Thanks Andy this was wonderful.

@vizwiz Год назад

Glad you enjoyed it

@user-mw6ek5sg1f 7 месяцев назад

OHHHHH ANDY U ARE SOOOOOOOOOOOOOOOOOOOOOOOOOOO INCREDIBLE , ITS SO HELPFUL ND I FOLLOW EVERY STEPS U TAKE ,THANKS SO MUCH ND GOG BLESS

@benardia7895 Год назад

Thanks a lot for the tutorial.

@wisnuher Год назад

This is simply awesome! Thanks!

@vizwiz Год назад

Glad you like it!

@rolandnwatarali9716 10 месяцев назад

Hi Andy, Always adding value to the Community with your awesome videos. Thanks. Quick question, i added a filter (Customer ID) on the filter pane (if you select a customer, it returns the sum of sales of that customers for the calendar year), However , when i select a customer ID, the calendar readjust (Not maintaining the original orientation). How do i keep the calendar fixed, while selecting different customers. Thanks again for the awesome videos. 👏

@SonofthewindsInc 10 месяцев назад

You are an inspiration ! I have just started learning tableau

@vizwiz 10 месяцев назад

Wonderful!

@weilingtang3249 Год назад

This is amazing. Thank you for sharing!

@vizwiz Год назад

Glad you enjoyed it!

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

Brilliant, as always..!

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

Thank you! Cheers!

@erjimsnobe2219 7 месяцев назад

Absolute legend!

@abhaysingh-ve6gg Год назад

Looking amazing... thanks for sharing this

@vizwiz Год назад

Thanks for watching!

@josephsparacino144 6 месяцев назад

Thank you so much for this video. I was able to create a proportional circle and a density circle calendar map based off of your idea.

@vizwiz 5 месяцев назад

Great job!

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

Thanks!

@joeliddiard3102 Год назад

Love this! Gong to use this to visualize our Hubspot Deals. Thanks!

@vizwiz Год назад

You’re welcome 👍🏻

@sir-cute Год назад

Hi Andy, When other dimension filter selections are applied, the calendar skews showing only those days which have metric values. Can this be avoided so that the full calendar continues to show despite the selections ?

@kodkkt20 18 дней назад

Thank you Andy for this magnificent tip, quick question; when I am using any filter or parameter, the calendar shows the related period, not the full-year view, how can I include filters/parameters to the calendar view?

@formulamaxima 2 месяца назад

"I hope you find this tip useful" Dude... this is not a tip, this is a masterclass

@vizwiz 2 месяца назад

Thanks for that!

@monikarompoti5594 Год назад

Hello, thank you for this! Is it possible to add 2 text objects in the worksheet with different alignments and font sizes? I would like to add text in the calendar to have both the sales of the day and the number of the date

@laterr2 Год назад

Hi Andy and thanks for the video. Question : If I add a filter Country/Region set as United States, some days doesn't show up anymore. Any idea to bypass this ?

@sir-cute Год назад

This is super useful. Thank you. I am trying to solve a small issue. When the metric is null, the cell color is white. But when the metric value is 0, the cell color shows up gray. I want the cell color to be zero for nulls as well as for zeros

@francescaamato4191 7 месяцев назад

I was able to recreate the calendar heat map but am struggling when I add filters - similar to if you would add a department filter to the sales heat map, when I select a value from the filter it distorts the heat map. I understand this is happening because when you add a filter it is no longer pulling in every date from the full outer join - any ideas how to work around this? I would like the calendar to remain unchanged when using the filter except for the color on the date.

@marjidcustalow3803 4 месяца назад

Hi Andy, this was so cool, and I am using the structure today! I have one sticking point, maybe you can help I am using the Heat Map in a dashboard contain with a cross-tab sheet with several data columns (not the date scaffold but the data connected to it) in it If I set the cross-tab sheet to filter and select any column cell the heat map responds as it I would expect (showing only the days applicable to the cell I selected) My problem, if I select a data on the heat map my cross-tab goes blank, nothing shown - what I expect was the map would filter the cross-tab and show only items relative to that date. Any help correct my error would be most helpful and appreciated. Thanks Zach

@yyz619 6 месяцев назад

Hi Andy, is there a way to show the pure calendar? we have a team at work that would like to show their teams shared calendar on a large monitor or TV so the week’s tasks and assignments are visible in their common area huddle space throughout the day. The screen will be vertical, and we would like to show the current month, next month, and the month after next month only, and be able to add/edit on the specific day block on the calendar. Is that possible to do in Tableau? Thanks

@stephaniejones4675 Год назад

Hi Andy, this is awesome - thanks so much. I am using something I learned in another one of your videos, using a parameter to allow the user to dynamically select which measure they want to see using a calculated field in the view, with Quantity = 1, Sales = 2, and Profit = 3. The Adjusted Sales (or in my case, Adjusted - Measure Selection) works fine when the parameter is Quantity or Sales, since they don't have negative values. But for profit the Adjusted Measure calculation throws off the heatmap diverging colors because -1 is set to grey, so it just makes the days without Profit metrics a sea of greys that blend with the non-profitable days instead of a nice negative diverging color scale and white for the days without profit. Any ideas for a workaround?

@vizwiz Год назад

Use a diverging palette and set the center to 0.

@martakuzniar5587 5 месяцев назад

When I add sum of sales to the color, it still shows me one color. What am I doing wrong?

@shaquellejacobs7930 Год назад

I have been using scaffolding for awhile now thank you I now know the terminology of it. How can I apply this concept in the transportation industry?

@vizwiz Год назад

It's industry agnostic for sure.

@marcelofigueiredo3878 Месяц назад

Great! There's a way to have Sunday as first day of the week?

@vizwiz Месяц назад

Right click on your data source, go to date properties, change the start of the week.

@Kashiroymaru Год назад

So, I'm using the superstore dataset directly from Tableau public website, and the order dates only go to 2017. I looked at your link but don't see where to download the updated dataset.

@vizwiz Год назад

Here's a copy - 1drv.ms/x/s!AhZVJtXF2-tDgYZeRRzJlz30XxSibw?e=jpNJ0J

@Kashiroymaru Год назад

@@vizwiz Awesome, thank you.

@ducquach6580 Год назад

Hi Andy, an awesome video & I learnt so much from it. I have a question. but not sure it is relevant to this video. How to I joint a primary data source of a SQL stored procedure to the scaffold excel spreadsheet? as Tableau does not let me joint stored procedure with another data source. I attempt to blend them, but it does not work as expected. Any comments would be much appreciated. Many thanks, Andy.

@vizwiz Год назад

Instead of a stored procedure, how about creating a view in SQL?

@ducquach6580 Год назад

Thank you very much, Andy. I will have a try. Many thanks again for a precise, easy to follow and well informed instruction video. 😊

@vizwiz Год назад

@@ducquach6580 my pleasure. 👍🏻

@comeonforfs Год назад

Fantastic tutorial! What if you wanted to use a date Range as a filter. So that you dates can span across a two years. E.g. Oct 2022 - Feb 2023? Ive tried it and it doesnt seem to put the dates in a sequential order. It always starts the calendar with January on top. Any ideas how to fix this? So that it shows Oct -22, Nov-22, Dec-22, Jan-23, Feb-23 in correct order. Thanks in advance!

@comeonforfs Год назад

I think I resolved it easily by adding a Year(date) dimenions in the row shelf!

@vizwiz Год назад

Exactly what I was going to recommend. Good job!

@ikayhargley 5 месяцев назад

@@comeonforfs does this handle FY scenarios? and adding the year(date), is it in addition to the quarter(Date) and Week Offest in the row? Thanks @vizwiz

@nowfeleusuf2294 Год назад

Hi I am facing a little challenge. When I try to use the Calendar as a filter, the contents on other containers do not show up. However, upon checking, the contents come back. Grateful for your direction.

@ikayhargley 24 дня назад

did you find a workaround to this?

@nazeerhussainrockstar Год назад

Great video. Any one any idea how i can do this in Google Data studio

@vizwiz Год назад

No idea, sorry

@aynismayil4092 Год назад

How can I synchronized dashboard with calendar?

@vizwiz Год назад

I don’t understand your question.

@dayana11day Год назад

How use calendas as filter?

@vizwiz Год назад

Once the sheet is on the dashboard, click on the filter icon on the upper right of the sheet.

@aynismayil4092 Год назад

How can i change format of months? i want they be bigger, but not dates

@vizwiz Год назад

Right click on the field you want to change and choose format.

@thiruvarulselvan8718 Год назад

How to download this workbook sir?🤔

@vizwiz Год назад

The link is in the description. Did I forget to say that in the video?

@rjjxt Год назад

But don't you think this scaffolding technique gonna be irrelevant when we have a large dataset

@vizwiz Год назад

Why would that matter? You're only adding a single column and only rows where the dates don't exist.

@rjjxt Год назад

I actually joined the two datasets as full outer by creating a calculated field in each of the data set as 1 and joined the both on that calculated field having nothing but 1, so I guess it kind of or did union so the size increased

@BESegal 10 месяцев назад

Andy: This is very useful. I found that using the calc "Order Date Week Offset" as you show it in the video meant that in some months of a single year returned wk 0 for the first day of the month and other months wk 1. And this meant that the 1st week of each month didn't always align visually for all the months. So I modified the calc making the Fixed LoD portion to the level of Year & Month dateparts rather than Month datepart alone. See below. Did I miss something in your video that otherwise accounts for the issue I discovered? BES (aka pc v ga) As shown: DATEPART('week', [Order Date]) - { FIXED DATEPART('month', [Order Date]) : MIN(DATEPART('week', [Order Date]) ) } How I modified it: DATEPART('week', [Order Date]) - { FIXED DATEPART('year', [Order Date]), DATEPART('month', [Order Date]) : MIN(DATEPART('week', [Order Date]) ) }