How to make Calendar like chart using a scatter plot

How to make Calendar like chart using a scatter plot

This article talks about how to make a Calendar like a chart using a scatter plot. Follow the steps below.

1). Add a scatter plot in your analysis.
2). Note [Courier Start Time] is the date of interest here by which we will plot calendar.

Use the following expressions in the scatter plot Properties tab:

a). X Axis :  <BinByDateTime([Courier Start Time],"DayOfWeek",0)>
b). Y Axis :  Week([Courier Start Time])
c). Trellis : Select Panels Radio button and add expression <BinByDateTime([Courier Start Time],"Year.Quarter.Month",2)>
Choose Manual layout and Set Max Number of Rows as 4 and Max number of Columns as 3
d). Labels : UniqueConcatenate(DayOfMonth([Courier Start Time])) and Select to Show labels for All .
e). Shape : Select Tiled Markers
f). Marker by : <UniqueConcatenate([Courier Start Time])>
g). In Y axis, choose Reverse scale and Multiple scaling for each trellis panel.
h). Color : Set expression BinByDateTime([Courier Start Time],"DayOfWeek",0)

Scatter plot will be presented as Calendar.