When creating a dashboard that utilises a lot of JS I am constantly finding myself 'editing' widgets just to gain access to the 'Edit Script' button. There is also no way of indicating if a script exists other than 'editing' the script to check. I t...
Hi Community, I'm trying to figure out why my pivot table is returning incorrect values, and how to fix it.I need a variety of formulas that apply to each program in my pivot table to collect data about how much money we are contracted to receive, ho...
By default, the format of all data labels in a widget is the same. So sometimes its bit difficult to identify which data label is belongs to which series/legend. We can use below script to set background color of data label same as series/legend and ...
Is there a method or formula to use a lookup, but only obtain the first instance that has a real value, and not a null (n/a) value? In addition, is there an explanation manual available of formulas which a person with no IT skills can use to underst...
Lookup([RaaS_CurrentStaffingReport 1],[Last Hire Date],[Sisense Employee Number],[Employee Number]) Is it possible to use a lookup formula to find and show data within the same table? If not, what would the correct formula be? The above shows no da...
Hi Sisense community, My goal here is to calculate the total number of subscriptions churned between the current week and the last 4 weeks. However, I am getting an error that says there is an issue querying the data model - would anyone be able to ...
Is there a way to drag/drop or move dashboards from one folder to another? During development, multiple folders were created different developers and I want to condense all dashboards into one nice logical file structure. I don't see ability to dra...
I'm using the Jump to Dashboard plugin and am seeing an issue where one of the filters is appearing twice in the drill down dashboard. The drill down dashboard does not have a date filter on it to begin with. The parent dashboard does have a date ...
Is there a way to default the 'To Date' to latest date or Today always, so when the user runs the dashboard it will be refreshed for latest date, now the user have to manually select the To date to latest date every time they run the dashboard
On my dashboard, I want to default use palette for 5 charts and for 1 chart only use 1 color where bars represent months. I was using this dashboard level script to override automatic palette colors and turn all widgets to a single color (works grea...
Hey, I have converted Column chart into Waterfall chart using the script provided in Sisense Community. Now my concern is the values are not showing in an appropriate manner, I need the value to be displayed on top of the each bar, and negative value...
I am fairly new to sisense. I have this situation as below: I have connected sisense to a "Sample Sales" SQL Server Database with 2 Tables: Database : Sales_db Tables : tb_sales_summary : 2. tb_sales : In Sisense I have done an inner join o...
I have the following code that formats the pivot table seen below: widget.on("ready",function(w, args) { var headerBgColor = '#a90a40'; //Header background var headerFontColor = '#F2F3F2'; //Header Font Color var footBgColor = '#44546A'; // Pivot...
I have created multiple actions sets so that multiple dashboard filters will be affected by a single click and users will not have to remember the filters they need to change or just make it easier to filter. However, now I have a bunch of action but...
Hi All, Is there any way to set the borders for particular individual widgets in the Dashboard? I have found the Dashboard script where it will apply the the style settings for all the widgets in it. But would like to know to set the style settings f...
