I've built a widget that uses RSUM to sum the values for multiple rows/RSUM of Fiscal Period of Year as shown in column Avg YTD Revenue shown in the two screen shots below: Works great. However, if I filter the pivot down to a single Fiscal Period th...
I have a few columns in the database that are encrypted. I checked with my data warehouse team and they said it is something Sisense is doing. Does anyone know how to decrypt these columns?
I'm wondering if there is a widget script available to enable "drilling down" into a category of a Funnel Chart. When I right click on a Funnel Chart category, no menu appears. Drilling down is available for Pie Charts, which summarizes data in the s...
Hello, How could I calculate weighted average in the widget's formula section ? Thanks
Hi Team,I am creating a gradient heat map for pivot and using this script. But, this only works for the second column. I tried to tweak the var tag but it's not working, can anyone help me with this.Thank you cc: @harikm007 // select color theme from...
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 table A...
Hi Team, Is their any method to connect Sisense to SharePoint if any please let me know Thanks in advance,
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 filt...
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...
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 futur...
I want to hide a column until the user drills into the chart. Example of what it currently looks like below: I would like to hide the "Videos in Module" until the user clicks the drill into. So it would look like this initially. Then when a user clic...
Hi Team, I have created a Jump to Dashboard from a widget. However, I am seeing from couple of months that the arrow signal specifying the JTD widget is now superimposed with the title of the widget leaving it very clumsy.Any help regarding the same ...
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.
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 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])>450001...
