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. ...
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...
Hi Team, Please assist with the below use case: Use Case: End-user wants to save multiple views once user apply a set of dashboard filters, for example there is a category filter added in the dashboard which has multiple drop-down values as a,b,c,d,e...
When using RSUM over a category, and when the RSUM has underlying values only for some early periods of time, and not later periods, it sums in the NULLs from those future periods showing values extending into the future. I do want the RSUM to be con...
Hello!I'm looking to play around with the Dashboard Header parameters. More specifically, I'd like to do the following: 1. Truncate the Data As Of parameter to the day (aka remove timestamp) 2. Play around with the display of the Dashboard Filters. F...
By default values and labels are displayed in tooltip. Also its possible to add additional information to tooltip by using script . Sometimes it would be more helpful to display a widget as tooltip (Reference) Steps: Create base chart - the chart in ...
I am trying to achieve a pivot table format, where there are multiple column headers under one. I am attaching the screenshot for the format here. As the fields are text and date fields, i am not able to achieve that format directly through the pivot...
I have the following blox widget: with the following code: { "style": ".blox-slides:not(:first-child) .blox-pivot-title{display:none} .blox-slides .blox-pivot-title{margin-bottom:10px; font-weight:bold; color:black; font-size:1em}", "showCarousel": f...
