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 ...
![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 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...
When creating a column chart and formatting it to include "Values", you might find out that the bars cover the column values. The following (widget) code manipulates the columns' height and label position: const labelHeight = 25widget.on('domready', ...
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 wanted to sort Legends in Pie Chart Manually according to my wish. Any information or code related to it will appreciated.
Hello, I need to create report for top and bottom performers for a parameter. It should be based on overall percentage and not by Ranking. How can I achieve the same using Sisense? For example: In below table, top 30% performers are highlighted in Re...
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...
