When creating a bar chart you'd sometimes want to rename the categories/break-by fields Modify the "Break-By" Category Names Apply the following widget script: widget.on('processresult', function(widget,result) { // Translation Dictionary let dict = ...
Different marker symbols can be set to line chart based on its value (Y-axis) using this script. But in some cases we may need to set icons for each category (X-axis), Here is a script to achieve this https://www.binextlevel.com/post/set-marker-symbo...
Hi, I can't figure out how to use the Accordion plugin on a BloX widget. Any help is appreciated, thanks.
Hi Community, I'm trying to figure out why my pivot table is returning incorrect values, and how to fix it.I need a variety of formulas that apply to each program in my pivot table to collect data about how much money we are contracted to receive, ho...
Hi, I have 2 questions about formatting sparklines in BloX. 1. Is there a way to make the width of the sparkline dynamic, rather than hard coding it? 2. How can I remove all the white space above my first textblock? I have the margin-top set to zero ...
Morning! Is there a way that I can track the previous month's exceptions alongside the current month? The left widget is working as intended with the max value listed being the total exceptions of the previous month, and the ~46k is the current exc...
Hi, I have a problem with Sisense localizationOur React application has a language switcher that we can use to change the language through the i18n library, but how can I change the localization of the Sisense widgets at the moment of language switch...
Hi, Below script will display total value at the center of donut chart. Refer - https://www.binextlevel.com/post/add-data-label-to-center-of-donut-chart var titleText = '' var labelColor = '#4287f5' var labelFontSize = '24px' widget.on('processresult...
Hi all, I am creating a pivot table widget in Sisense and the values are all showing up as 0. I double-checked the widget JAQL and they're all using the same table so that shouldn't be the issue. I also checked the Sisense analytics for the table and...
In various cases, you'll require additional data from your data model - Data that wasn't part of your original widget's query. The following function allows you to query your data model as part of your javascript code (using your existing security to...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
Trying to change the widget title background color. I am using custom css code for card look. The following widget code allows me to change border radius/color. Trying to use similar "widget-header' to no avail. Any ideas? Thx! $('.widget') .css('bor...
I am using a BloX container as a title. I have white space below the container (see picture). "spacing": {"padding":0} in Configuration. BloX script below. Is there a tip to remove the white field space below the container? { "style": "", "script": "...
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
