Topics with Label: Code-first Analytics

How can you Count the number of patient with more than one AppointmentId in the same day

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

TypeError: Cannot read properties of undefined (reading '0')

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

Plugin Directives- Proper way to send JAQL Query data to plugin directive

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

How to set two filters using a Input.date blox widget?

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

Default Selections - Multiple Tabbers

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

Resolved! HIDE WIDGET WHEN EXPORTING TO PDF

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

Geo Map GL Widget Plugin

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

Build function on custom table not working.

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

"Where" Function

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

Lookup Limited to Rows without a Null Value

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 Formulas referencing one table

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

Resolved! PREVENT EXPORTS

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?

Sisense Community

Forum Posts