Freezing columns while scrolling in Pivot2 Linux
Hi Team, Can anyone help on freezing first column of pivot in linux while scrolling. Thanks Nazeer
Forum Posts
Resolved! Can't get text to vertically align between columns in Blox widget
I'm struggling to get the text in 2 adjacent columns in a Blox widget to align. It doesn't even really matter how, top/middle/bottom, as long as there is some degree of alignment. I created a very basic test script to see what's going on and essentia...
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...
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...
Formula to Return SUM similar to a SQL IN Statement in a GRAND TOTAL
Scenario: My organization has ACCOUNT that have multiple balances associated with them, and each account has a TYPE These accounts tie into a PORTFOLIO We have a Pivot that is to return all PORTFOLIOS and the SUMs of these ACCOUNTS. But we would like...
Client Specific Custom Fields - Dynamic Field Names (Metadata Translator)
Hello, our clients create their own custom fields and I would like to display them in Sisense with their client-specific names. I have followed the directions in this article implementing the Metadata Translator but the documentation about the plugin...
Plugin Directives- Proper way to send JAQL Query data to plugin directive
Hi All, I have been able to get an AngularJS to run on Sisense based on Aggregated Table Plugin code. The problem I am facing is how to get the processed result data into the directive, without using the scope. widget.js console.log('d3Angular Report...
Dynamic Goal Line with dropdown selection
Hello, I used a widget feature I found from binextlevel: https://www.binextlevel.com/post/filter-dropdown-in-widget and our users liked it however they want to take it to the next level and have a (dynamic) goal line added to it. Basically, every tim...
AccumulateBy with Connection change
Hi Team, I have cube with 800M rows and it is currently building incrementally. I got scenario where my DB source upgraded and I should change my connectivity of cube. What should happens if build a schema build? will my build bring only latest data ...
Next quarter instead of Past Quarter on widget level
Hi, I'm looking to replace the 'Past Quarter' function on the widget level with the 'Next Quarter'. I see that there is no in-built function as such for that, ca someone help me how I get that function on the widget?
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...
Select seared results from the filter
Hi everyone, Does anyone know if we can only select the searched result from the filter?
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 data...
Resolved! Passing Date Filter into Pivot Formula
Hello! I was wondering if anyone has passed in a date parameter into a Pivot Table Formula before. If so, how best can I accomplish this? I have a begin count of employees and end count. There is a count for every day and this report can be run off o...
