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...
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...
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 appe...
By default, the format of all data labels in a widget is the same. So sometimes its bit difficult to identify which data label is belongs to which series/legend. We can use below script to set background color of data label same as series/legend and ...
Is there a method or formula to use a lookup, but only obtain the first instance that has a real value, and not a null (n/a) value? In addition, is there an explanation manual available of formulas which a person with no IT skills can use to understa...
Lookup([RaaS_CurrentStaffingReport 1],[Last Hire Date],[Sisense Employee Number],[Employee Number]) Is it possible to use a lookup formula to find and show data within the same table? If not, what would the correct formula be? The above shows no data...
Hi Sisense community I have imported an excel sheet into my elasticube data model and would like to display the columns in the excel sheet in a pivot table in a widget. I do not want to aggregate the values from the Excel sheet using SUM() or COUNT()...
I'm using the Jump to Dashboard plugin and am seeing an issue where one of the filters is appearing twice in the drill down dashboard. The drill down dashboard does not have a date filter on it to begin with. The parent dashboard does have a date fie...
When creating a pie chart you'd sometimes want to emphasize the difference between pie slices by displaying an "exploding effect" based on the pie values.This will be performed by teaching Sisnese a new visualization known as a "variable pie" Apply t...
![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, My goal here is to calculate the total number of subscriptions churned between the current week and the last 4 weeks. However, I am getting an error that says there is an issue querying the data model - would anyone be able to a...
On my dashboard, I want to default use palette for 5 charts and for 1 chart only use 1 color where bars represent months. I was using this dashboard level script to override automatic palette colors and turn all widgets to a single color (works great...
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 . Please...
Is there a way to default the 'To Date' to latest date or Today always, so when the user runs the dashboard it will be refreshed for latest date, now the user have to manually select the To date to latest date every time they run the dashboard
Is there a way to drag/drop or move dashboards from one folder to another? During development, multiple folders were created different developers and I want to condense all dashboards into one nice logical file structure. I don't see ability to drag ...
