How to make a Calendar like chart using a scatter plot.

How to make a Calendar like chart using a scatter plot.

This article talks about 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). 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 :

b). Y Axis : Week([Courier Start Time])

c). Trellis : Select Panels Radio button and add expression

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 :

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.