I recently had a colleague asking me to show him the data in a calendar format.. Something like this
I basically used a scatterplot for this. You can check out the original DXP here
Some key settings to make it a calendar. Please note Order date is the date of interest here
These expressions are out of the box expressions, no need to handcode them, but select them in the axis value
X Axis <BinByDateTime([Order Date],"DayOfWeek",0)>
Y Axis Week([Order Date])
Trellis into panels <BinByDateTime([Order Date],"Year.Quarter.Month",2)>
Manual layout 4 X 3
Labels UniqueConcatenate(DayOfMonth([Order Date]))
Shape Tiled Markers
Marker by <UniqueConcatenate([Order Date])>
Happy plotting your calendar!!!
Cool stuff!
ReplyDeleteTwo more settings are needed on the y-axis to get this to work correctly:
- reverse scale
- individual scaling for each trellis panel
I just have to say it again. This is awesome!!! Thank you so much!!!
ReplyDeleteThank you!!
DeleteGreat creation....................Looking for more ideas like this
ReplyDeleteThis visual is an excellent idea! we would like to implement a version of it and it's dxp will be a great help but it doesn't work. Can you please fix it? When I click on it: http://spotfiretipsntricks.blogspot.com/2014/07/calendar-chart-in-spotfire.html
ReplyDeleteI get 404
Can anyone make this work now with SF 7.0?
ReplyDeleteI am not able to make the week of date render with individual scales as it shows unable to render with multiple scales with a categorial axis.
Otherwise is OK,
Thank you for the great tip!!!
ReplyDeleteI was able to do this in Spotfire 7.0, only thing is the calendar is in reverse order. Week (Y axis) in reverse order.