Resolved! How to calculate weighted average in widget's formula section
Hello, How could I calculate weighted average in the widget's formula section ? Thanks
Forum Posts
Resolved! Dynamic heat map for Gradient color in pivot
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...
Enable/Disable Pivot columns based on selected filter
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...
Sisense connectivity
Hi Team, Is their any method to connect Sisense to SharePoint if any please let me know Thanks in advance,
Can you export/copy over set of dashboard filters from one to another dashboard (same data model)?
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...
Script to reduce the size of the pie chart category labels is attached below
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...
Resolved! Dashboard time filter from dynamic TODAY until forever
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...
Resolved! Hide column until drilled into
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...
Jump to Dashboard arrow mark superimposed with widget title
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 ...
How to hide a column in a table widget?
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.
Filter by two values on same widget
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...
Custom Blox Filter for measure
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...
Show/Hide dashboard column button
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...
Jump to Dashboard feature limit
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...
drill down from one widget to another widget
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.
