Calendar Chart in Spotfire

Before we start, I would like to ask one question :
🤔Do you think representing data as colors on a calendar will be great ?

If your answer is YES, then here I have -"How to do it "⛄
Requirements :

• You should have one column of Data type "Date".
• Number of Data Points should be sufficient to be shown as a calendar. In case of missing Dates, the values will not appear in chart (As above).

Steps:

1. Insert a Scatter Plot
2. Set X-Axis Expression to
   DayOfWeek([Date])
3. Set Y- Axis Expression to
   Week([Date])
4. Change Y Axis scale setting to Reverse Scale.
5. Use multiple scales on Y-Axis for Each Trellis panel.
6. Use trellis for showing 1 month in one trellis panel. Some Sample ways are -
• Split Panel by BinByDateTime([Date],"Year.Quarter.Month",2) with manual layout.
• Limit Data to show only a few months and then use columns by months BinByDateTime([Date],"Month",0)
7. Set Shape to Tiled Markers.
8. Set Labels to show all and Expression set to DayOfMonth([Date])
9. Set Colors as per requirements.
10. Hide Y Axis Labels.
11. Hide Axis Selectors.

Now you have a calendar chart ready to use  🤓

Vivek Kumar