How to make calendar-like chart using a scatter plot in TIBCO Spotfire

Product:TIBCO Spotfire Analyst
Versions:All versions

Summary:
How to make a calendar-like chart using a scatter plot.in TIBCO Spotfire

Details:
This article explains how to make a calendar-like chart using a scatter plot

Resolution:
Follow the steps below:

1. Add a scatter plot in your analysis.
2. Use the following expressions in the scatter plot Properties tab (Note: [Date] is the date column of interest here by which we will plot the calendar):

• X-Axis:  <BinByDateTime([Date],"DayOfWeek",0)>
• Y-Axis:  Week([Date])
  • Choose "Reverse scale" and "Multiple scaling for each trellis panel.
• Trellis: Select Panels Radio button and add expression <BinByDateTime([Date],"Year.Quarter.Month",2)>
  • Choose Manual layout and Set Max Number of Rows as 4 and Max number of Columns as 3
• Labels: UniqueConcatenate(DayOfMonth([Date])) and Select to Show labels for All .
• Shape: Select Tiled Markers
• Marker by: <UniqueConcatenate([Date])>
• Y axis: 
• Colors: Set expression BinByDateTime([Date],"DayOfWeek",0)

The scatter plot will be presented as calendar:

See the attached Calendar.dxp for an example.