Introduction
For this week’s challenge, we are creating a calendar heatmap. There is no default visual for this, and many of the custom visuals are not very flexible, but Deneb has us covered.
Requirements
Create a calendar visual:
- Show day of the week on rows and week on columns. (Hint: If you get stuck on how to handle the week, see this great calendar heatmap from Davide Bacci.)
- Add small multiple columns and rows so you have month on columns and city on rows.
- Use the max temperature (TMAX) values to color the marks.
- Use one of the sequential single-hue schemes available in Vega-Lite (the example uses “oranges”).
- Order the cities by latitude descending.
- Add a legend above the calendar.
Create a tooltip report to appear when hovering on a date in the calendar heatmap:
- Fields to include: Date, Location, Max temp, Min temp
Dataset
This week’s data comes from the National Centers for Environmental Information. Go to https://www.ncei.noaa.gov/access/search/data-search/daily-summaries.
Use the following inputs:
- Data types: Maximum temperature, Minimum temperature
- Begin date: 2022-01-01
- End date: 2022-12-31
- Stations: USW00023234, USW00094290, USW00093134, USW00024229
Configure the downloads with the following properties:
- Output format: csv
- Include Attributes: yes
- Include Station Location: yes
- Include Station Name: yes
- Units: Standard
Share
After you finish your workout, share on Twitter using the hashtags #WOW2023 and #PowerBI, and tag @MMarie, @shan_gsd, and @KerryKolosko. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year.
Solution
Need some inspiration? Check out Calendar Example.
Tried replicating this visual and attached the link , https://www.novypro.com/project/developer-to-data-4