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.
I have a pivot table on which I have implemented Jump to Dashboard. The dashboard that it jumps to contains only a table widget. This widget is getting populated correctly. However, the widget has quite a few columns; more than what will fit on the s...
I want a Progress Bar that will display my current sales in comparison to the target. I found a similar tutorial and followed it exactlyThis is the tutorial I followed : https://profusion.com/insights/custom-bar-charts-in-sisense-blox-with-diego-cord...
Hi I am trying to format a stacked 100 bar chart. I am looking for help on 3 things Re-order the break by's. I want the smaller amount on the left (see first image) I want to round the corners of the bars. (see second image) If rounding the corners i...
I want to set specific colors for the bars in my bar chart by dimension or category. I do not want to use break by because some values aren't in the data yet. How do I achieve this in edit script?
