Hi, I need to have a searchable input text (see image attached) that say searches by country name (a field in a dimension table). Once I type in say "Australia" and hit "Apply", the dashboard should filter accordingly. The key requirement is for the ...
Is it possible to have end users save filter settings (beyond the default option)?
I have several pivots and tables that require scrolling through. Given that I have a dark background, the scroll bar is hard for users to see. I’d like to change the color to improve the user experience. Ideally, this would be done at a high level, b...
I have a dashboard with six KPIs across the top. I am using an existing dashboard as a temple. The existing dashboard uses BLOX for the widgets. I created the first of the six KPIs by pulling in the unique members in the data. By default, Sisense "na...
Hello, I am facing an issue regarding Scatter Maps. I have a dimensional table including some store codes, in which I left joined some latitude and longitude coordinates, as shown in the schema below. When I create the scatter map, I want to use the ...
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...
