Hi Team,I have calculated the manufacture share on pivot table at two levels ( Retailer and Category) using the formula:dupcount([custom manufacturer_sort])/(dupcount([custom manufacturer_sort]),all([custom manufacturer_sort]))Now, the default grand ...
I’m trying to switch the displayed data based on a user selected filter.This would be done in Power BI using something like the below:Value = SWITCH(TRUE(), [Selected Item] = “A” , Sum(A), [Selected Item] = “B” , Sum(B), [Selected Item] = “C” , Sum(A...
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...
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 ...
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...
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 =...
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...
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...
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...
Hi, I need help with 'customizing-an-indicator-widget'. Refer to the jpeg image. What I've tried so far: From the below image. I currently have built widget image (1) What good looks like: What triggered me is the post linked below, and widget image ...
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?
Hi Team , Script to reduce the size of the pie chart category labels is attached below widget.on("beforeviewloaded",function(widget,args){ var maxCharNum = 28 var value args.options.plotOptions.pie.dataLabels.formatter = function (){ value = chunk(th...
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.
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 w...
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...
