Download: Time Series
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.
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.
If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder.
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)
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.
May 30, 2017 - Added some additional datetime format options, added support for datetime datatype as x-axis, fixed issue with x-axis label formatting
Oct 20, 2018 - Removed value labels on plot area, changed grid lines to dash, improved sizing for split chart view
Please sign in to leave a comment.