Download: secondsFormatter.zip
INTRODUCTION
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, 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.
IMPLEMENTATION:
Step 1:
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.
Step 2:
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)
NOTES
- 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.
