Sorting on two columns in table widget
I want to sort a table widget based on two column, first sorting based on Column A and then Sorting based on Column B so it will come within sort values of column A, is it possible is sisense table widget
Forum Posts
Resolved! Widget script for specific condition in Column chart
Below is a script that I had added for an indicator widget. If the secondary measure gives a result greater than 1, the widget will show NA. widget.on('render', function (se, ev) { if(se.queryResult.secondary.data > 1) { se.queryResult.value.text = "...
Resolved! Responsive Blox
Hi, I have created few KPIs using Blox which looks aesthetically very appealing. However, my users work on different resolution and scaling on different machines and all the built-in charts (line chart, bar chart, column chart) gets adjusted accordin...
Repeating rows in a pivot table
it possible to repeat rows in a pivot table instead of having them grouped at the beginning? Thanks
Scroll Through Blox Cards
I have built a series of cards using Blox and would like for the carousel arrows to actually move through the cards themselves and not just the data, any way to do that?
Multiple graph in same widget
hello I am new to sisense can you please help me to achieve the view below if it is possible at all
Showing X Number of Columns
I have several columns in my Sisense pivot table widget since I'm using dates as a column. However, since Sisense limits up to 73 rows. Instead of the first 73 rows, I would like to get the last 73 rows. Can anyone help out with how I can do that? Th...
Blox Card that Jumps to a Specific Widget in a Dashboard?
I am new to Blox, the dashboards that have been built were done with the standard Sisense elements not Blox. I would like to build blox cards that have a jump-to button that jumps to their corresponding widget that is in the dashboard that has alread...
Wrong range in dynamic buckets
hello I am using dynamic buckets to show number of customers in each spend range for the selected time period, I am using the dynamic bucket plugin. My issue is the highest bucket range i.e. 800 is wrong as the maximum spend I have in my view is 741 ...
Pivot table showing both grand total and grand average below eachother
For a business dashboard one of the requirements is to show the average and grand total (see attached file). As far as I know, Sisense only allows one of them. Is it possible through e.g. a widget script to include this behavior? Kind regards,ScheurK...
Resolved! Using Coalesce with Lookup in a custom column
I need to create a custom column on one of my tables. This column will be a LOOKUP from another table. However, if the current row has no match in the remote table, I want to use the value from the current match column. Here is what I am attempting t...
Resolved! Values on Rows
In my table, Values are arranged vertically as columns (first table in my screenshot). How can I move the Values so that they are arranged horizontally as rows (second table in my screenshot)?
Resolved! Hide the left [Dashboard list] and right panel [Filter List]
Hi, Is there a way to hide the left [Dashboard list] and right panel [Filter List] for a dashboard? The aim is to restrict user from manipulating the filters and not jumping to other dashboards from the left and right panels Thanks, Rahul
Resolved! Pivot 2.0 Javascript resizing strangely
Hello, I have used the following javascript before to modify results within a column of a pivot table, but when I try to do the same for column table objects I get strange behavior. Here is the javascript I use to modify the pivot table. widget.on('r...
Resolved! Is there a way to pass specific filters for Jump to Dashboard?
I have a pivot table with a few columns with JTD enable to another dashboard. However, I want the OldestNoteDateofVisit column to not pass as a filter. Is it possible to exclude specific column to be passed as a filter in JTD?
