Seconds Formatting
Download: Link
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, 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.
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.
-
Wow you just saved me so much time in developing call times for our call center! Our call center managers will be so happy this is able to show them how much time it takes for call-to-answer etc in a readable format! Thank you!!!
Is there any way to add this to the plugin "Overlapping Column Chart"?
-
Hi Takashi, thanks for this plugin! I was wondering if there is a way to fix the allignment problem I have when I utilize this plugin on a pivot table. The value in the column is not horizontally alligned with the rest of the values on the same line. The time formatted value is a little higher than the rest..
-
This is great, much better than have to script specific columns widget after widget. Two requests / suggestions:
In my pivot, the result right-aligns in the cell directly against the edge (doesn't have the margin space to the right that the original value did). Also, the result is top-aligned rather than middle-aligned like all other values are.
Could these two items be addressed in your next improvement?
Thanks!
-
How can I do custom formatting on numbers ?
In India, a different numbering system is followed (Lakhs/Crores), where 1 Lakh = 100,000 and 1 Crore = 100 Lakhs (10 million)
So, if it is 1M, how do I display it as 10L (10 Lakhs), or 10M as 1Cr (1 Crore) ? And similarly, fractions/decimal points/multiples ?
Thank, Roopesh
Please sign in to leave a comment.
Comments
7 comments