This article explains how to install and format time in seconds in Sisense.
This plugin adds a button to the widget editor, which allows a dashboard designer to specify that a value contains seconds and should be automatically formatted. This solution combines a few earlier posts for specific widget types (indicator, pivot, bar/column) into a single plugin and works on indicators, tables (pivot/table), and any Highcharts based widgets (bar, column, line, area, etc). For the chart widgets, this plugin supports axis labels, value labels, and tooltips.
Download the attached .zip file.
Extract the .zip file into the following path: "[Sisense installation path]\PrismWeb\Plugins".
If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder.
On your dashboard, open the widget editor and click on a value's setting menu. You should see a new option for "Time Formatting" that will automatically handle formatting
The formatting used here is standard HH:MM:SS, and also days (if applicable)
- The default formatting is defined in the dateFormatter function, if you want to adjust the output, simply change the code here.
- This plugin assumes time is in seconds. If your time is in milliseconds, adjust your formula to divide by 1000.
Please sign in to leave a comment.