Hi All, I'm trying to change the starting day of the Week in Cube level, Need to calculate Total Hours worked by an employee from Saturday to Friday. If I choose Week range(week 1, week 2, etc..) then my week selection should calculate total hours fr...
When creating an area chart you'd sometimes want to use a gradient-fill the area of the chart (linear or radial) Linear-Gradient Fill (Top-to-Bottom) Apply the following widget script: function hexToRgbA(hex,opacity){ var c; if (opacity < 0 || opacit...
Team, I am using Sisense.js to embed Sisense widgets to my applications, just want to understand the ways that how can I give export to csv option . Looking for an eportcsv button kind of solution. Thanks, Nazeer
When creating a line chart, you might want it to color differently for values below the threshold. Add the following script to your widget: widget.on('processresult', function(widget, result) { let dataSeries = result.result.series[0]; let threshold ...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
Hello, is there any way how to make piechart looks better on mobile devices?It has 800px width by default and it's shrinking the whole screen.
I'm attempting to create a custom(advanced script) date filter on a widget. My base table has dates in the future for forecast planning, but I only want the widget to show results from: "2020-01-03" to: "today". (I want getdate() or similar) Is there...
Hi, does anyone have a script to custom sort the order of categories on a Funnel Chart? Thanks.
Below script will add gradient color to widget. Supported widget types are bar chart, column chart, line chart and area chart Steps: Create bar/column/line/area chart Add below widget script and update the variable 'color1' with any color you need to...
Is it possible to change the font color for bar chart hover labels? Ideally this would be a global setting, but if I have to run code per widget, ill do what it takes. Thanks!
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...
