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.
Hi,I am trying to create two boolean Custom Columns in my DimDate table to flag data in the current week, and data in the same week, previous year. This type of flag is easy to create for a monthly resolution, but weeks are tricky because they can sp...
Hi All,I have the following use case:I want to visualize the overall stock level of 2 different products over time. The source for the stock levels is a FACT table containing the log data of the stock movements. The FACT table is connected to a date ...
Any help gratefully received, please.I've hit a wall: apparently I cannot use three parameters in a measure on a widget. Anyone know of a work around?[Total total_client_facing_hours]-sum([work_department],[work_title],[Total total_capacity_hours_on_...
Hi All! I wanted to share a problem our team was having with "corrupt" widgets AND how we solved it. From time to time, after a widget is deleted on our more complicated dashboards, the widget box still appears in the dashboard BUT the OID no longer ...
Hello, I could not find any solution for changing the color of pivot1 cell value in a particular column based on some threshold value tried with some sample scripts but did not get it can you please help me out in this. Color should be applied only t...
Can we format [Font, Size, Alignment, Border, Text color] of the Tabber headers? Also, can we set default selection for one of the tabber options? Thanks, Rahul
Hi all, I hope you would be able to help with this. I am creating a dashboard with the week dates as rows, and cumulative sales and sales as 2 columns (as shown in the image below). The cumulative sum is for the last 30 days only , so RSUM() would no...
Hi, If you are trying to implement a clickable URL in your pivot tables, and you are trying to follow the following article: Clickable URL Links In Pivot Rows You are going to get a pivot table with all the HTML code () instead of a clickable value. ...
Hi Community We have an issue in downloading pivot widget to pdf. In sisense windows environment we have Pivot widgets in these widgets some columns are hidden we made this hide in script but when we download a particular widget to pdf it is showing ...
