Boolean Datatype
Hi, I want one column in my pivot chart to have boolean datatype. Is there a way to convert it to Boolean format instead of Text? Regards, Rahul
Forum Posts
Sorting Table
Hello,I have created an "Aggregated Table" widget using this plugin.Using this, sorting the table by only one column is supported. Is it possible to sort the table based on 2 columns in descending order? Perhaps something can be done using widget scr...
Sisense Cloud(Linux) limitations
Hi team! I'm looking for information about Sisense limitations, like the maximum number of ElastiCubes, tables per cube/instance, columns in a table, dashboards, etc. I've been trying to find such information in the documentation but with no luck. Is...
Selecting a large volume of variables into a filter
imagine a dimension has 1500 variables and someone wants to select 600 of them in a filter. Is there a way to avoid manually selecting each variable individually?
Jump to Dashboard - Date issue
Hello, I have a trend graph that consists of 3 values: (example below) I have applied a Jump-To-Dashboard in order to be able to show on a simple pivot table, a breakdown of the data per day for the selected month. As you will notice (in red), in my ...
SUM([TEXT_FIELD]) stopped working after latest upgrade!
We're connecting to Sisense via Live-model on Snowflake DWH when you use function sum("TEXT_FIELD") on snowflake it will create an auto-cast to numeric even though the type listed as varchar. if the varchar contain text value the sum will fail. Until...
count number of rows in table with aggregation in a new column dynamic on filter
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 wil...
Date Filter is not working when selecting beginning of data & End of data ,Today
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 sisense ...
Searchable Input Text That Displays the Value Selected
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 ...
Saved filters at user level
Is it possible to have end users save filter settings (beyond the default option)?
Is it possible to change the scroll bar color?
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...
Blox Widget
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...
Scatter Map - Details not working
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 ...
RSUM not producing desired result when filtering
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...
Option to drill down in Funnel Chart?
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...
