Hello, I've been trying to build build a widget (NUMBER) where I get the total Count of PatientId with more than one appointment in the same day... I was able to build a pivot table but I am confused when I try to replicate the calculation in other ...
Hi, We are seeing the error message mentioned in the subject for two types of charts (Area map and Scatter plot). For Areamap, this error is throwing up 16 times on hovering over the tool tip. For scatter plot, the same error is multiplying on hoveri...
Hi All, I have been able to get an AngularJS to run on Sisense based on Aggregated Table Plugin code. The problem I am facing is how to get the processed result data into the directive, without using the scope. widget.js console.log('d3Angular Re...
Hi, I currently have two filters that apply to different widgets on my dashboard. Note that the two filters have different grains, one is at day and the other is at month. I have a single blox widget with a Input.date. Is there any way to add a butto...
I am trying to make two dynamically related tabbers that behave like this: TABBER 1: has 5 tabs with FINANCIAL as the default selection. This works without any issues. Tabber 2: I am trying to incorporate a 2nd tabber that is dependent on the CASE...
Is anyone aware of a script/method other than plugins for excluding a specific widget when exporting to PDF? I want to exclude a Tabber widget when exporting to pdf. Thanks! -Carter
Hi Sisense Community. I have used the Geo Map GL plugin to create a map that shows the sales amount per state in only the US and Canada. However, when I hover over the map, there is no value label. I can't find much documentation on Geo Map GL online...
I have attempted, in the data source section of an elasticube/dashboard to build with changes only on a custom table (green). After 8 hours, the custom table continues to show "unbuilt changes" and at various intervals a separate table (brown) shows...
Can the "where" function be used in a lookup formula to limit the rows looked at to only result in values that are not null or only a specific value or partial value? I am attempting to use a lookup formula, where the value being used to look up app...
Is there a method or formula to use a lookup, but only obtain the first instance that has a real value, and not a null (n/a) value? In addition, is there an explanation manual available of formulas which a person with no IT skills can use to underst...
Lookup([RaaS_CurrentStaffingReport 1],[Last Hire Date],[Sisense Employee Number],[Employee Number]) Is it possible to use a lookup formula to find and show data within the same table? If not, what would the correct formula be? The above shows no da...
I have the following code that formats the pivot table seen below: widget.on("ready",function(w, args) { var headerBgColor = '#a90a40'; //Header background var headerFontColor = '#F2F3F2'; //Header Font Color var footBgColor = '#44546A'; // Pivot...
I am attempting to replace a value of N/A with another field in a table. I continue to receive the value of "N/A" which is in the "Working Title" field with the formula below. Is this the appropriate formula? The actual value that appears in the w...
I have the following BLOX widget: Which is generated via this BLOX code: { "style": "", "titleStyle": [ { "display": "none" } ], "script": "[].slice.call( document.getElementsByClassName('blox-date') ).for...
I have two questions after searching through the community: HOW DO YOU PREVENT A WIDGET FROM BEING DOWNLOADED? HOW DO YOU PREVENT USERS FROM EXPORTING AN ENTIRE DASHBOARD TO PDF?
