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?
How do you display duplicate records of say names for example grouped by days in a table?
Hi everyone, I have a peculiar scenario where we want to make a filter 'mandatory'. It is a single select filter with a pre-defined value but we don't the users to select none. Is it possible?
I got the Python dataframe output as below. >>output = pd.DataFrame(data=mymodel,columns = ["Y"])>>print(output)>>SisenseHelper.save_dataframe(output) Would like to see how to reuse the output in other blocks or save it within the Sisense Notebooks.
We have been using blox date gran template successfully for number of months. https://support.sisense.com/kb/en/article/change-date-granularity-of-a-widget-using-blox The issue is it is using server setting for week start date - for our server this i...
I have a pivot table that works for my team. It looks like this: The variance column is a simple formula showing the difference between Budget and Revenue (Revenue - Budget). I have received a request to expand this pivot (or create a new one based o...
ElastiCube error. Error details: BE#184269 Failed to build custom table: staff_bw. SQL: MALException:run_default_logic_inst_prll failed:failed to apply parallel default logic operation: 'CMD_LT_int_prll'. This is whenever I add my case statement in m...
When creating a dashboard that utilises a lot of JS I am constantly finding myself 'editing' widgets just to gain access to the 'Edit Script' button. There is also no way of indicating if a script exists other than 'editing' the script to check. I th...
I want to add a custom script for my widget using this option I have a calendar filter on my dashboard like below It is being carried forward to the widget like so Our fiscal year is Oct to September.Now, my requirement is that whenever user sele...
