Seconds Formatting

Follow

Takashi Binns

March 05, 2018 17:09

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.

6

• 

  Victor Frank May 09, 2018 22:13 (Edited May 21, 2018 18:31)

  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"?

  0

  Comment actions Permalink
• 

  Oren Zamski September 23, 2018 04:22

  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..

  0

  Comment actions Permalink
• 

  Oren Zamski September 23, 2018 06:02

  To be more specific on my previous question - The style for the new Second Formatted field is not inherited from the stylesheet of the dashboard/the pivot table. How can I fix that?

  Thanks,

   

  Oren

  0

  Comment actions Permalink
• 

  David Rogers July 12, 2019 20:38

  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!

  0

  Comment actions Permalink
• 

  David Rogers July 26, 2019 14:02

  Additional enhancement request: When the value being formatted is NULL, can you make it so that no value is displayed (consistent with how Sisense presents NULLs elsewhere)?  Thank you.

  1

  Comment actions Permalink
• 

  Roopesh Ambrath November 13, 2019 14:30 (Edited November 13, 2019 14:31)

  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

  0

  Comment actions Permalink
• 

  David Rogers March 05, 2020 16:56

  Do you have any expectation of enhancing this excellent plugin to address my two previous requests?

   

  Thank you for providing this, saves a ton of imperfect widget scripting.  But, the slight formatting differences and lack of NULL handling limits its use.

  0

  Comment actions Permalink

Please sign in to leave a comment.