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

Forum Posts

Unwanted Join Path

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

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

Resolved! Drill Through

Hi Team, Is their any option like drill through in Sisense and if any please let me know how to do it.

Resolved! Sparkline with total value

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

zohebakber_1-1672654287792.png

Resolved! Dynamic Text Widget

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

Is it safe to delete PrismWeb logs

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

prajwal by 7 - Data Storage
  • 804 Views
  • 0 replies
  • 0 kudos

Resolved! Window function in sisense

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  

Report Manager: Error notification alerts not send

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

psharma by 8 - Cloud Apps
  • 962 Views
  • 0 replies
  • 0 kudos

Resolved! RSUM with Display Missing as Zero

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

wallingfordce_0-1668564755888.png wallingfordce_1-1668565250014.png

Resolved! RSUM with Display Missing as Zero and BreakBy

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

wallingfordce_0-1669833150334.png

Showing last 12 months based on end date

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

Screenshot 2022-12-06 at 13.52.33.png
dim4a91 by 7 - Data Storage
  • 1318 Views
  • 1 replies
  • 0 kudos

Adding indicator to pivot table

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

Retrieving previous rows data in Sisense Data Modeling

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

adityak by 7 - Data Storage
  • 1106 Views
  • 2 replies
  • 0 kudos

Deselect stacked Column chart legend value by default

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

Gramsey by 8 - Cloud Apps
  • 3830 Views
  • 5 replies
  • 1 kudos

Resolved! Pivot2: Replace a value in a specific value in another column

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

Check out our Software Developer Communities!