Hi Team, Can anyone help on freezing first column of pivot in linux while scrolling. Thanks Nazeer
I'm facing an m2m error on one of my widgets. From the Analyze Widget JAQL view, I can see the issue is that inventory.tenant_id and vendor.tenant_id are not connected directly to tenant.id. The problem is that they are joined directly in the elast...
Hi Team, Is their any option like drill through in Sisense and if any please let me know how to do it.
Hi,I am using the below script to show the sparklline along with the total value in the y axis.Can anyone suggest me as to how to show the Average Value.. widget.on('processresult',function(se,ev){ev.result.chart.backgroundColor = '#5181c9'ev....
Hi, I am looking for a solution where I can add a text with dynamic numbers according to the values/formula given.For Example: Best country in terms of Profit is "India".In the above statement Country(India) is dynamic. As an, the country might chang...
Hi, I found that "C:\ProgramData\Sisense\PrismWeb\Logs" occupied 5 GB space. This folder is not mentioned in Sisense documentation for clean up. SO is it safe to delete these logs? And please mention if you have any other suggestions on cleaning up ...
Hi, Is there a SQL limitation in Sisense for Window function? I have checked the syntax but it is not working when I am trying to create a new custom column. Please find the attachment for reference
Sisense report manager doesn't send alerts when a scheduled report fails to run. In recent errors we had an issue where Sisense report manager hung on scheduled reports in running state. The support team was able to deploy a hotfix to resolve that is...
When using the feature to Display Missing Values as Zeros, the results are what I would expect for a simple SUM. However, for an RSUM the results should fold the zeros into the value within RSUM and not return zeros for the RSUM itself.In this image,...
I got ahead of the user on this one...Solved: RSUM with Display Missing as Zero - Sisense Community...and found out only after getting a great solution that the user has a field in the Break By. Anyone gracious who can expand the script to work over ...
Hello! I'm struggling to build the following logic for my report: I need to show last 12 months data based on time frame selected. For example, if the user selects 04/2021 - 09/2022 time frame - the chart should only show 12 months before 09/2022. An...
Hi Team, Is their any option to add indicators to the Pivot tables based on the values. For Example:if value is zero than it will be red color tickif value is greater than 0 & < 1k than orange color tickif value is >1k than green tickThanks in Advanc...
Hello all, I have a requirement where we need to get the value of last row's ending balance as beginning balance of the current row and this process should carry on for next 100 rows. And we don't have any base table for this and everything is build ...
Hi, I'm looking for help deselecting a stacked Column chart value by default. Use case: I have a stacked column chart stacking a metric (# of Actions suggested) by date. Lets say I have 4 actions: Run, Hide, Fight, and No Action - over 90% of my da...
Have this script to find and replace a specific cell value with another value: function getWidgetDocumentObject(widget) {if (prism.activeWidget == null)return document.querySelector('[widgetid="' + widget.oid + '"]').querySelector('pivot2');elseretur...
