Build Analytics
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Starting day of a week Changes

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

Area Chart - Gradient-Fill (Linear/Radial) Area

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

Ophir_Buchman_0-1651238999794.png Ophir_Buchman_1-1651239015628.png Ophir_Buchman_2-1651239235721.png Ophir_Buchman_3-1651239698634.png

Resolved! Export a widget to CSV in Sisense.js

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

Nazeer by 8 - Cloud Apps
  • 5 replies
  • 0 kudos

Line Chart - Line Conditional Formatting

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

Ophir_Buchman_0-1651215608626.png Ophir_Buchman_1-1651215624773.png 83227784_3726975083979609_8570336295451099136_n[1].jpg

Responsive PieChart

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.

vmaik by 7 - Data Storage
  • 1 replies
  • 0 kudos

Dashboard Custom advanced Filter

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

jacobgould by 7 - Data Storage
  • 1 replies
  • 0 kudos

Gradient color in bar/column/line/area chart

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

harikm007 by 13 - Data Warehouse
  • 0 replies
  • 0 kudos

Resolved! Hover label value font colors

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!

ElementUX by 8 - Cloud Apps
  • 3 replies
  • 0 kudos

Pivot2 export to csv format

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

Laris_Fdz by 8 - Cloud Apps
  • 1 replies
  • 0 kudos

BloX pivot with grand totals

I'm using the BloX transposed pivot template below: How can I add a column on the right that shows the grand total of each value?

Vlad by 8 - Cloud Apps
  • 5 replies
  • 1 kudos

bringing carousel for images in Blox .

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

rameshp0233_0-1651050415667.png rameshp0233_1-1651050515222.png

Funnel chart tooltip customization

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

Nazeer by 8 - Cloud Apps
  • 1 replies
  • 0 kudos

How to switch off Pivot2 columns?

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

Laris_Fdz by 8 - Cloud Apps
  • 2 replies
  • 0 kudos

How to update old pivot widget to pivot2 ?

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

Wojtek by 9 - Travel Pro
  • 0 replies
  • 1 kudos
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?