Core issue: Dashboard filter is showing selectable categories which have no values in the table used by the dashboard. Example: I have a dashboard which presents data from the Charges (fact) table below. There is no reference to the Inventory table ...
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;}); B...
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 ...
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:...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
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 wan...
How do you display duplicate records of say names for example grouped by days in a table?
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?
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.
Hi Sisense Community! I am currently building a sales dashboard and would like to compare actual sales numbers and sales target. However, the data that I have for actual sales is only until the current date, but the sales targets are until end of yea...
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...
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 th...
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(){ ...
I am working on importing a flat file (CSV) with a large number of columns (~350) into an elasticube. When I go to build the cube, even when only using a small number of sample rows, I get an error that says "Memory allocation has failed for <column ...
Can the "where" function be used in a lookup formula to limit the rows looked at to only result in values that are not null or only a specific value or partial value? I am attempting to use a lookup formula, where the value being used to look up app...
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...
