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

Forum Posts

HTTP Error REST_API Jupyter Notebook

Hi, I am using REST_API from the custom code section and want to query my elasticube but i am getting a below error:{'error': {'status': 401, 'httpMessage': 'Unauthorized'}}I am using the below query:logical_sql_res = sisense_conn.get_logical_sql(que...

mbjamil92 by 7 - Data Storage
  • 152 Views
  • 1 replies
  • 0 kudos

How to create a new column with percentiles?

In Sisense, I'm looking for a way to create a new column in a table, with percentile values of a different column.I am open to design suggestions/approach. What the best way to accomplish this.Such that: 1. Have a filter created on percentile values ...

percentiles.jpg
leo82 by 8 - Cloud Apps
  • 404 Views
  • 1 replies
  • 0 kudos

Resolved! How do i disable toggle switch button in filterpane?

Hi,For my dashboard, I would like to disable or delete the toggle switch buttons in the filter pane (shown in the picture), so the users of the dashboard do not have the option to turn them on or off.I can't seem to find the option in menus. Is it po...

frankmol_0-1684152551795.png
frankmol by 8 - Cloud Apps
  • 660 Views
  • 4 replies
  • 0 kudos

Changing fontsize in pivot2 breaks PDF-export

Hey,So I used the following widgetscript to alter the font in a pivot-table. In the dashboard these alterations are visible, however when exporting it to PDF the pages are all blank. widget.transformPivot( {}, function (metadata, cell) { cell.style =...

HamzaJ by 12 - Data Integration
  • 200 Views
  • 1 replies
  • 0 kudos

Displaying Opening Balance for Date Range in Pivot Table

Hey everyone, I’ve got a table with an opening balance that shows the date and total quantity on that date. There’s another table I’m working with that has transaction details and their values (transaction date and quantity). What I want to do is dis...

Laflet by 8 - Cloud Apps
  • 129 Views
  • 0 replies
  • 0 kudos

Accessing custom columns/tables from Notebooks

I'm looking for ways to access custom columns/tables that are created within Elastic cube data models, from `Notebook` feature within Sisense. Context: We have a Sisense cloud account We have a Elastic cube (EC) model that is built from Snowflake dat...

prakashp by 8 - Cloud Apps
  • 222 Views
  • 1 replies
  • 0 kudos

Days Since [Days in Date] Issue - Unexpected token

Hi, In the past this formula worked for me to count the number of days since a date: DDiff(NOW([Days in date]),[Days in date]) but now I am seeing this error* Function Syntax Error: Unexpected token 'DDiff(NOW' *screenshot attached Has anyone else ex...

Screen Shot 2023-03-21 at 12.01.41 PM.png
vrice by 8 - Cloud Apps
  • 430 Views
  • 2 replies
  • 0 kudos

Keep changes made via script to a widget when downloading

I have made several changes via widget scripts, such as changing the background color of specific cells. When I Download this to Excel or PDF, these changes don’t come through. Is there anyway to make these changes come through on Download?

Laflet by 8 - Cloud Apps
  • 475 Views
  • 2 replies
  • 0 kudos

How to hide a column in a table widget?

Does anyone know how to hide a column in a table widget? I saw the old post here (https://community.sisense.com/t5/build-analytics/pivot-2-0-hiding-columns-from-the-display/td-p/3607) for pivot table but that doesn't work on table widget. Thank you.

DXC by 7 - Data Storage
  • 1128 Views
  • 5 replies
  • 0 kudos

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

subhak by 7 - Data Storage
  • 208 Views
  • 0 replies
  • 0 kudos