Is there a way to add a some simple date range input fields to a dashboard so that viewers can easily set just those parameters withour having to get accueas to a full filter panel? Something like a simple start/end date.
Hi Sisense Community - I would like to change the numbers in the column chart to the month names (e.g 1 should be 'January', 2 should be 'February', and so on...) The examples I found online only manage to change the labels in the x-axis from numbers...
The Growth and DiffPastPeriod function with weeks does not work for us in Sisense. Works with day, month, quarter and year. + Why do these functions count strangely if you select more than one day, month, quarter, year? For example: if I selected Mar...
Hi all, does anyone know how to get the data labels to the center of a donut chart? I would also like to reduce the width of the secondary value (like the orange part below). Thanks
Have this script to find and replace a specific cell value with another value: function getWidgetDocumentObject(widget) {if (prism.activeWidget == null)return document.querySelector('[widgetid="' + widget.oid + '"]').querySelector('pivot2');elseretur...
When creating a line chart you'd sometimes want to add a range area to emphasize an "Acceptable Range". The following script will allow you to create a widget that looks as follows: Notice the following modifications were made to the original widget:...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
Hi Sisense community, I would like to order the months in my column chart according to the logical order, but right now it's mainly showing alphabetical order. Would anyone be able to assist on this? Ideally I would like to achieve it on the frontend...
Hello, I'm using Sisense Linux and I have a pivot table that I'm using to stoplight certain locations with green, yellow, or red. My 1st column is location(like NYC), my 2nd column is text status(GREEN), and my 3rd column is number status(3). I would...
I am trying to create a dashboard that contains a Blox widget with custom hyperlinked resources in it. This was what I came up with. Does anyone have a better idea/suggestions for achieving this? { "style": "", "script": "", "titleStyle": [ { "displa...
I am using Generic JDBC connector to import data from our MongoDB.For certain requirements, I want to only import data from the past 7 days wrt the current date using the timestamp field present in the data.I have tried a bunch of regular SQL functio...
Hello Community, i am looking for a solution of wrapping text in pivot pdf export. By using the below code i am able to wrap text in dashboard but not in pdf. this.afterResultLoaded = function (args) {$('table', args.element).css('table-layout', '');...
I am seeing odd behavior in a pivot table widget. This is a widget that has been in production for some time, and it gets updated once a week with a new batch of data. This week, for the first time, the column headers are out of alignment with the da...
Hello, We want to use color palette in such a way that the pattern will repeat from initial color from palette for every column. But in Sisesne its just giving out random order as shown in the attached pictures. Any suggestions would be appreciated. ...
When creating a bar chart and formatting it to include "Values", you might find out that the bars cover their values. The following (widget) code manipulates the bars' width and label position: const labelWidth = 25 + 5 // 5 is the space between the ...
Hi, Sisense Community,I use DiffPastPeriod() and PastDay() to show previous day's values or to calculate the difference with the previous day. BU the problem is that I don't have data for Sundays and it seems like the formulas DiffPastPeriod() and Pa...
