Is it possible to calculate the total number of rows in a table with aggregation in a new column which will update dynamically on changing the widget filter? For E.g. If the total number of records are 58, then all the values under the new column ...
Hi Sisense Team , I am WVC Team member .In date filter if I selecting anyone of beginning of data & End of data &Today options is not working for our expectation. I tried this date filters in both live model and elastic cube model . Pervious sisen...
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 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 "n...
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 ...
Is there a way to get a full list of folders? I am are using the /folders API, but this only pulls information for folders that I own. I do have admin access to our Sisense instance and am looking to be able to retrieve the folder IDs and folder name...
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...
Trying to change the widget title background color. I am using custom css code for card look. The following widget code allows me to change border radius/color. Trying to use similar "widget-header' to no avail. Any ideas? Thx! $('.widget') ...
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?
Hello, How could I calculate weighted average in the widget's formula section ? Thanks
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 ...
Hi Team, Is their any method to connect Sisense to SharePoint if any please let me know Thanks in advance,
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 cl...
Hi Team, I am looking to create a pivot where where I would like to have input from the user in one of the fields as a feedback form.Please see the screenshot attached.Here, I want to take the input in the last columns in the screenshot below. Any he...
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...
