If a widget contain large number of bars/columns, sometimes it may be difficult to analyze the chart. In such case one option is to enable Auto Zoom feature in widget which will enable a scroll bar in chart. Alternative option is to add pagination in...
When formatting your widgets you might choose to display values using K/M/B/T abbreviations. When doing so, the corresponding tooltips display the values in the same format. In case you want to show the full-form number, use the following dashboard s...
Can anyone recommend the best-practice approach for defining each widget ID as its own variable so that I can reference the names in this script instead? I'm having a difficult time keeping each tab accurately updated. This is what I have currently c...
Hi Team, I am new here. I am trying to read the value of a widget to the Edit script and trying to customize the widget based on data value. For example, if I have an indicator or a smart label widget and could see a number or value in it. How can I ...
I am trying to remove the Total text portion from the subtotal row so that it only reads the row value - COTA (highlighted in yellow): Referencing this KB article, I was able successfully this with the manual text replacement, but I'd rather it be dy...
Here is how you can include more information in tooltip. Steps: Create column/bar/line/area chart In this approach, result of disabled Values panel will display as additional information in tooltip . So create and disable Values panel as required. Ma...
Hi! I am currently facing an issue with one of my dashboards - rows with null values are being hidden after some filters are applied. This affects other columns of data, since some of them use RSUM. The RSUM values are wrong since the rows with null ...
Hi, When hovered over a region/state in an Area map, can we add extra lines of details [column values] in the tooltip that pops-up after hovering? Also, it would really be helpful if we can achieve it for other chart type as well. Thanks!
Here is a script to convert pie chart to semi circle donut widget.on('processresult', function(se, ev){ ev.result.plotOptions.pie.startAngle= -90, ev.result.plotOptions.pie.endAngle= 90, ev.result.plotOptions.pie.center= ['50%', '85%'], ev.result.plo...
When attempting to apply formatting to a Pivot 2.0 chart you might find out that it doesn't apply to the Sub-Total and Grand-Total rows. The following (widget) code applies conditional formatting to negative numbers: function getWidgetDocumentObject(...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
When creating a column chart, you may want to control the width of the columns. To do so add the following script to your column widget: const newWidth = 5widget.on('domready', function(widget) { try { console.log('DOM Ready script starting (wid=' + ...
In Accounting, it is common to represent negative numbers with leading and trailing parentheses. For example, negative two hundred is displayed as "(200)" To change a negative number formatting in a pivot 2.0 chart - Add the following script to the p...
When attempting to apply conditional formatting to a Pivot 2.0 chart you might find out that you can only control a cell's background color. However, if you want to control the text color itself - Try to add this code to your Pivot widget: function g...
Hello Sisense Community, Despite on-line HTML references, I cannot properly code a BloX "text" string to change color of specific words in the text line. I'm sure this is straightforward coding; can't find an example in other BloX templates. I have a...
After applying security for users on dashboards and particular widgets, the users who are restricted for the widgets are seeing error exclamation mark on the widget instead of no result. Any inputs are appreciated.
