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

Forum Posts

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

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

Adding a column with no aggregation

Hi Sisense community I have imported an excel sheet into my elasticube data model and would like to display the columns in the excel sheet in a pivot table in a widget. I do not want to aggregate the values from the Excel sheet using SUM() or COUNT()...

amelia by 10 - ETL
  • 7 replies
  • 0 kudos

Jump to Dashboard - Date filter is added twice

I'm using the Jump to Dashboard plugin and am seeing an issue where one of the filters is appearing twice in the drill down dashboard. The drill down dashboard does not have a date filter on it to begin with. The parent dashboard does have a date fie...

cglowe by 8 - Cloud Apps
  • 0 replies
  • 0 kudos

Pie Chart - Exploding Pie

When creating a pie chart you'd sometimes want to emphasize the difference between pie slices by displaying an "exploding effect" based on the pie values.This will be performed by teaching Sisnese a new visualization known as a "variable pie" Apply t...

Ophir_Buchman_0-1653547136278.png Ophir_Buchman_1-1653547150927.png 83227784_3726975083979609_8570336295451099136_n[1].jpg

Resolved! PREV query getting error

Hi Sisense community, My goal here is to calculate the total number of subscriptions churned between the current week and the last 4 weeks. However, I am getting an error that says there is an issue querying the data model - would anyone be able to a...

amelia by 10 - ETL
  • 4 replies
  • 0 kudos

Resolved! Use color palette for certain widgets and single color for others?

On my dashboard, I want to default use palette for 5 charts and for 1 chart only use 1 color where bars represent months. I was using this dashboard level script to override automatic palette colors and turn all widgets to a single color (works great...

ElementUX_2-1653482983659.png ElementUX_1-1653482773351.png
ElementUX by 8 - Cloud Apps
  • 2 replies
  • 0 kudos

Max # of columns in source table

I am working on importing a flat file (CSV) with a large number of columns (~350) into an elasticube. When I go to build the cube, even when only using a small number of sample rows, I get an error that says "Memory allocation has failed for . Please...

mattmca by 9 - Travel Pro
  • 3 replies
  • 0 kudos

Folder Organization - Moving Dashboards

Is there a way to drag/drop or move dashboards from one folder to another? During development, multiple folders were created different developers and I want to condense all dashboards into one nice logical file structure. I don't see ability to drag ...

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

Custom code fails to build

Hi all, We created custom code in one of our elasticubes. However, after a week it fails, usually with the following error: "timestamp": "2022-05-24T06:00:31.697Z","verbosity": "Error","type": "buildEnded","message": "Failed to build custom code tabl...

ScheurK by 9 - Travel Pro
  • 1 replies
  • 1 kudos

Waterfall Chart to show values on top of each bar

Hey, I have converted Column chart into Waterfall chart using the script provided in Sisense Community. Now my concern is the values are not showing in an appropriate manner, I need the value to be displayed on top of the each bar, and negative value...

Manjusha_0-1653378934773.png Manjusha_0-1653378628821.png
Manjusha by 7 - Data Storage
  • 0 replies
  • 0 kudos

Unwanted categories in dashboard filter

Core issue: Dashboard filter is showing selectable categories which have no values in the table used by the dashboard. Example: I have a dashboard which presents data from the Charges (fact) table below. There is no reference to the Inventory table i...

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


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


Change Action Sets with Multiple Filter values to Dropdown List

I have created multiple actions sets so that multiple dashboard filters will be affected by a single click and users will not have to remember the filters they need to change or just make it easier to filter. However, now I have a bunch of action but...

jmn3 by 9 - Travel Pro
  • 0 replies
  • 0 kudos
Community Toolbox

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

Email [email protected]