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