Time Series Chart - Visualizing Hrs/Min/Sec
Download: Time Series
Introduction
The OOTB charts in Sisense limit the date roll-up granularity to days. This imposes limitations when working with granular times series data.
This plugin facilitates roll-up of dates up to the millisecond level. It also supports a split chart view which splits each measure into its own plot area.
Note: This plugin is an enhancement of the Highcharts Zoomable Line Chart widget.
Instructions
Download the plugin folder (TimeSeriesChart) and place it in your Sisense plugins folder. The Widget displays as Time Series Chart in the widget selection list.
C:\Program Files\Sisense\PrismWeb\plugins
If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder.
Data Preparation
This plugin accepts a date as a Unix Time Stamp - The number of milliseconds after Jan 01, 1970. You need to add an expression field in your elastic cube to convert your date field to a Unix Time Stamp.
Note: Set the column type to big-int.
(DayDiff([DateField], CreateDate(1970,1,1)) * 86400000) +
(GetHour([DateField]) * 3600000) + (GetMinute([DateField]) * 60000) + (GetSecond([DateField]) * 1000)
Options
Label Format - Sets the format of the markers on the X Axis.
Note: The Label Format setting will not roll-up the date. Use the formula to set the level of granularity. e.g. If you wish to roll-up the dates to the hour, then eliminate the minute and second portion of the formula.
Split Chart - Splits the chart into multiple plot areas, one for each measure in the Value panel.
Theme - Sets the color scheme of the chart.
Updated 03-02-2023
