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!!!
Hi, can you please further explain how you did that?
ReplyDeleteThanks!
Hi, Plz share how you have done this
ReplyDeletealso check an alternative solution i had pasted here in tibco community
ReplyDeletehttps://tibbr.tibcommunity.com/tibbr/#!/messages/92938
Still looking for a way to do it
ReplyDelete