Sometimes we need to hide or show few columns in pivot table based on a filter selected. Here is a script to achieve this. Reference: https://www.binextlevel.com/post/enable-disable-pivot-columns-based-on-selected-filter Steps: Create a Pivot tab...
We will be making series of dashboards that use the same model for diverse audience but would like to keep the same set of dashboard filters (in the same order) for uniformity across dashboard. Is there a way to export/copy over set of dashboard fil...
Hi. I have searched and cant seem to find this specific answer and I have tried multiple attempts of using currentdate(), today(), etc. I need a dashboard time filter that starts TODAY, end date doesn't matter as I can make it 20 years into the futu...
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 = c...
It would be great to be able to customize the default list of time frames in the filter options. For example Prior 12 months Current month + prior 12 months It is true that these can be created as custom filters and even starred, but users tend to lo...
Is there a way to have infinite scroll on Pivot tables, instead of pages? This is not available by default and was hoping this could be achieved via any scripts
Hello all, I am trying to create a custom column with the following conditions: IF ( (SUM([Sale Price])<361000, [Sale Price ]/1.2, SUM([Sale Price ])), (SUM([Sale Price])<450000, [Sale Price ]+21350/1.3, SUM([Sale Price ])), (SUM([Sale Price])>...
Anyone know how I can filter two values independently? In the chart below the first 4 bars are from my "days in R/I stage formula. The next 4 are related to the Insulation-Prime formula.Each formula has a filter built in to only look at jobs from the...
Hello, I was wondering if there is a way to create a measure filter in my case customer spend filter, where the user can define a number and the views are filtered by it? so basically I want to filter my view for customers who spent more than XYZ num...
I have a dashboard with 2 columns. I would like to have a button at the top that enables dashboard users to show/hide column 1. When column 1 is shown the column widths should be 40% for column 1 and 60% for column 2. When column 1 is hidden then the...
How can I hide the dashboard panel on the drill into dashboard however show the rows, values & columns in the expand widget view? Context: I'm using the Jump to Dashboard function on an indicator and restricting the dashboard panel from being display...
In the linux server, if we use multi servers, we want to build the cubes in one server and copy to the other serving nodes and attach the cubes. We were doing it by copying the data folder in the Windows environment previously. Now we are upgrading ...
Hi, We are facing this. We have a pivot table with shows the total amount of a metric and the running sum form the begining of the year (YTD). This is working fine: Then, we want to apply a filter based on the date column, to show just a couple of m...
Hi, having updated an elasticube model some of the relationships broke and I want to revert the changes back to the last built version; is there a way to do this easily? I can't go into the front end view of the model now, so only have access to the...
Hi Team, Do we have any option to drill from one widget to another in Sisense. if any please let me know. Thanks in Advance.
