On pivot2 table we have locale customization so thousands are separated with space and not with commas, decimal are separated with commas.When I try to export a pivot table to csv, our local setting are not applied so the numbers are downloaded in te...
I'm using the BloX transposed pivot template below: https://support.sisense.com/kb/en/article/transposed-pivot-table-with-blox How can I add a column on the right that shows the grand total of each value?
We had requirement that we had four images url in Array we want all the images in one image block all should show in carousel form .Any information related it will be helpful for us. we want script for below outcome
Hi Team, We are trying to customize the in built sisense Funnel chart tooltip to remove the value and just to display percentage and couldn't able to do this, as funnel chart is not supporting beforedatatooltip event. Could any one help me with this?...
I am looking for a script to switch off columns in pivot2. This option would be available to users, so I suppose I would link it to a Blox botton.The case is that we use dates in columns and several values. So when half of the month passes the table ...
HI, We have been applying custom script to pivot widgets and noticed that it doesn't work for some pivot widgets from older dashboards. It turned out that script only works on pivot2 widgets and not for previous version. We've tried duplicating widge...
Usually, when you want to color categories, you would use "break by", but then you cannot have two values on the same graph:I needed to show past year's values (grey on the left widget bellow) but on the same time color the categories like they are o...
Hello all, I noticed that the Color Heatmap widget ignores filters that are based on the same fields that are used in the widget's configuration. When this occurs, the widget's color is diluted (presumably to show that it has been filtered). For exam...
Hi,I've got a blox table widget that is narrower than the above line of widgets. It has 15 columns (1 is the name of the category and 14 are values)When I export the dashboard to pdf (actually I send it in email as pdf) the blox table gets cut, showi...
Hi all, I have an issue that could be easy to solve but I'm not getting the answer. I'm able to implement filters as BloX dropdown list (unique/multi selection), but the issue is that when I choose a value of the list, the filter it's appplied and, t...
Is there any way to freeze the header row in a pivot table, when the number of rows is very high it is difficult for users to scroll up and see what each column refres to
IS THERE A SCRIPT TO ENABLE VERTICAL SCROLLING FOR A LONG TEXT WIDGET?
I referenced this KB article to create a BLOX dropdown list as a filter. Here is a screenshot of my dashboard: The BLOX code I used to create the dropdown is at the bottom of this post. I want to filter the available drop down options to only show th...
When creating a column chart you might want to add a percentage value next to the actual value Add the following script to your widget: widget.on('processresult', function(widget,result) { result.result.plotOptions.series.dataLabels.formatter = funct...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
I have the following pivot: Why does the RSUM show a value of $0 on 4/3 instead of (92+428+0)? Thanks! -Carter
