Introduction The following article discusses how to manipulate the data and styling of your Pivot 2.0 widget.Please refer to the following article first: https://sisense.dev/reference/js/widget/pivot2.html. Cell Identification To manipulate a pivot c...
Hi! I am creating a pivot table and I currently have all the values populated until the end of this year. However, I would only like to include values up until the previous week, which is a dynamic date. Is there an advanced filter I could use that w...
Hi! I have an indicator widget that is updated weekly to show the latest weekly values. As such, I would like to have a line underneath this number that says something like 'updated as of *latest week date*' . The date would have to be updated based ...
I'm starting out trying to create Blox widgets. Most of these are not intended extend dashboard functionality to show sparklines and to put filters on the dashboard rather than to the side of it. So I'd like these widgets to fit in with the styling o...
A customer may want to pass a filter value using the URL (as a parameter). A common case could be when an external system launches a dashboard and wants it to default to a specific value.The following script allows you to parse the parameters receive...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
Sisense limits a user from defining more than 3 column values to make sure that the underlying SQL (group by) query doesn't get too complex (notice the missing '+'): However, in some cases, a user would like to add more than 3 values. These include: ...
When creating a bar chart, you might want to design it to have rounded corners To round all corners - Apply the following widget script: widget.on('processresult',function(widget,result) { result.result.plotOptions.bar.borderRadius = 10;}); Before Af...
When creating a column chart, you might want to design it to have rounded corners To round all corners - Apply the following widget script: widget.on('processresult',function(widget,result) { result.result.plotOptions.column.borderRadius = 10;}); Bef...
Hi, I am trying to create a new dimension base off of a case statement in the widget editor, but I can't get it to work (unless it's based on a value). For example, this first snippit (this is what I need) won't work . The second will. I don't want t...
I want to display a COUNT of 'Time Clock In' by Employee, and then I am going to do further math but the thing is, how do you turn it into a formula?
Does anyone know of a script that can be used to change the names of category values for a pie chart? I have the chart below which uses a binary value and I would like to replace these values with text.
Good morning - I would like to create a 'simple' numerical indicator widget with a sales value as the primary metric and the target sales value as the secondary metric. The target sales value is stored in an excel sheet with a structure like this: I ...
I have attempted, in the data source section of an elasticube/dashboard to build with changes only on a custom table (green). After 8 hours, the custom table continues to show "unbuilt changes" and at various intervals a separate table (brown) shows ...
The script below displays value of each items along with legend in pie chart. Refer : https://www.binextlevel.com/post/display-values-in-legend-pie-chart widget.on('processresult', function(se, ev){ ev.result.legend.labelFormatter = function(){ conso...
Is it possible to embed a dashboard or otherwise share a dashboard so that anyone with the link can view it without signing in? Data level security is not a concern for my use-case.
