Using Native Javascript Date Calculations To Modify Sisense Date Filters
Sisense natively supports various types of date filter functionalities. However, there are instances where a dynamically updating date filter is desired based on dynamically changing conditions such as the current date. Such a filter may not precisely align with the filters provided in the Sisense UI. One approach to achieve this custom behavior of a dynamically updating filter is through the use of dashboard or widget scripting.5.8KViews3likes13Comments
Error rendering tablewidget using sisenseJs
I'm getting a console error when calling the sisenseJs dashboards API function "load". The dashboard contains a table widget that seems to be causing the issues. The console error is "error refreshing widget: "Cohort Facility Details". (inner exception: TypeError: Cannot read properties of undefined (reading '$$loaded')) - TypeError: Cannot read properties of undefined (reading '$$loaded') " Cohort Facility Details is a table widget. Does anyone have any ideas what could be going on?5.1KViews0likes5Comments
Replacin 'NULL' with '0' in in calculations for column chart and pivot table
Hi all, For a culumn chart I calculated averages and divided the percentages into segments, the percentages do not add up to 100% After some searching I found out that this is because the 'NULL' values are not seen as '0' and therefore the calculation is not performed properly. See the pivot table below, for this pivot table I want to replace the null values with '0'. As can be seen in the updated table, it can be seen that the table generates null values but does not include them in the calculation of averages. I've already tried to solve this using IFs , but without success.Solved4.1KViews0likes4Comments
Can the indicator widget text be left aligned?
I'm embedding a row of indicator widgets (Simple Numerical type) using Sisense.js. The design spec I've got calls for the title and values to be left-aligned, but I can't find any way to make it not centered. I've tried experimenting with https://community.sisense.com/t5/knowledge/customizing-an-indicator-widget/ta-p/1770#toc-hId-764249051 but no luck. Anyone know of a way to do this?Solved3.9KViews0likes3Comments
DYNAMIC EMAIL REPORT SETTINGS
Hi Sisense Community! Please reference the screenshot below referenced in the following questions when configuring a dashboard's email settings: Is there a script to only export the active/visible widgets based on the Tabber selection? Is there a script/way to automatically run this for each location shown in the selected filter? So this would deliver 7 separate emails to the subscriber's inbox - one for each of the 7 locations. The Directors currently go into this report and filter locations one by one to then export & email a copy to the appropriate building manager. I'm looking for a way to remove that step and have it sent directly to the Director's inbox who can forward it from there. Note* the managers do not have access to Sisense otherwise I would have them just subscribe directly. Thanks! -Carter3.4KViews0likes4Comments
widget events firing too soon when embedded with sisense.js
I've added script to a blox widget on domready event that attaches a mouseover event to every blox slides. When the widget is embedded in an iFrame, the domready finds the slides. But when I am embedding the widget using sisense.v1.js, no slides are found. I suspect that the domready events fires before the blox widget has actually rendered the slides into the dom. maybe I'm wrong, maybe it has something to do with embedding inside a angular 10 app ?Solved2.8KViews0likes2CommentsVertical Grey Dividers
I have a dashboard that is embedded into a website. In the Sisense dashboard, I do not see vertical grey lines between my horizontal widgets. When the dashboard is embedded, grey lines appear and divide the widgets (see image below). There are four similar dashboards, but this issue only appears on one. I am using BLOX to create the widgets. I did find the following in the configuration section of the design tab for the widget: }, "separator": { "lineThickness": 1, "lineColor": "#eeeeee" }, #eeeee is grey, but does not appear to be the same shade of grey. This json appears in the configuration of the other widgets as well so I do not believe that is tied to the vertical lines seen in the website. Looking for advice on trouble shooting this in Sisense or direction on if there is a step between creating the dashboard and the client pushing it to the website that will remove those vertical lines.2.6KViews0likes3Comments
Using Native Javascript Date Calculations To Modify Sisense Date Filters
Sisense natively supports various types of date filter functionalities. However, there are instances where a dynamically updating date filter is desired based on dynamically changing conditions such as the current date. Such a filter may not precisely align with the filters provided in the Sisense UI. One approach to achieve this custom behavior of a dynamically updating filter is through the use of dashboard or widget scripting.
