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...
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...
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": "", "titleSty...
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 ...
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', ''...
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...
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...
This seems like a very trivial question, but I couldn't seem to find an answer. If I have a scatter chart, I would also like to show the calculated average of the x- and y-axis spanning across the chart. For example if the average of the points on th...
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...
I wanted to sort Legends in Pie Chart Manually according to my wish. Any information or code related to it will appreciated.
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...
Here is a script to convert pie chart to semi circle donut widget.on('processresult', function(se, ev){ ev.result.plotOptions.pie.startAngle= -90, ev.result.plotOptions.pie.endAngle= 90, ev.result.plotOptions.pie.center= ['50%', '85%...
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}", "sho...
Here is a current screenshot of my current blox widget: I made this starting from a default template that was available in my library (ref the attached STARTING TEMPLATE BLOX.JSON). For each of the 3 KPI's my goal is to add a trending sparkline w...
