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 http://bit.ly/spotcalendar 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!!!
Comments
Post a Comment