Skip to main content

Calendar Chart in Spotfire



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

  1. philippJuly 22, 2014 at 12:45 PM

    Cool stuff!

    Two more settings are needed on the y-axis to get this to work correctly:
    - reverse scale
    - individual scaling for each trellis panel

    ReplyDelete
  2. philippJuly 22, 2014 at 1:55 PM

    I just have to say it again. This is awesome!!! Thank you so much!!!

    ReplyDelete
  3. UnknownMay 27, 2015 at 3:52 AM

    Great creation....................Looking for more ideas like this

    ReplyDelete
  4. AnkitJune 29, 2015 at 10:56 AM

    This 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
    I get 404

    ReplyDelete
  5. dSETTERFebruary 18, 2016 at 9:11 PM

    Can anyone make this work now with SF 7.0?
    I 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,

    ReplyDelete
  6. UnknownSeptember 15, 2016 at 4:58 AM

    Thank you for the great tip!!!

    I was able to do this in Spotfire 7.0, only thing is the calendar is in reverse order. Week (Y axis) in reverse order.

    ReplyDelete

Post a Comment