How to make calendar-like chart using a scatter plot in TIBCO Spotfire

How to make calendar-like chart using a scatter plot in TIBCO Spotfire

book

Article ID: KB0071602

calendar_today

Updated On:

Products Versions
Spotfire Analyst All versions

Description

This article explains how to make a calendar-like chart using a scatter plot

Issue/Introduction

How to make a calendar-like chart using a scatter plot.in TIBCO Spotfire

Environment

All

Resolution

Follow the steps below:
  1. Add a scatter plot in your analysis.
  2. Use the following expressions in the scatter plot Properties tab (Note: [Date] is the date column of interest here by which we will plot the calendar):
  • X-Axis:  <BinByDateTime([Date],"DayOfWeek",0)>
  • Y-Axis:  Week([Date])
    • Choose "Reverse scale" and "Multiple scaling for each trellis panel.
  • Trellis: Select Panels Radio button and add expression <BinByDateTime([Date],"Year.Quarter.Month",2)>
    • Choose Manual layout and Set Max Number of Rows as 4 and Max number of Columns as 3
  • Labels: UniqueConcatenate(DayOfMonth([Date])) and Select to Show labels for All .
  • Shape: Select Tiled Markers
  • Marker by: <UniqueConcatenate([Date])>
  • Y axis: 
  • Colors: Set expression BinByDateTime([Date],"DayOfWeek",0)
The scatter plot will be presented as calendar:
User-added image
See the attached Calendar.dxp for an example.

Attachments

How to make calendar-like chart using a scatter plot in TIBCO Spotfire get_app
Powered by Wolken Software