Resolved! Display Only Duplicate Records Grouped By Date
How do you display duplicate records of say names for example grouped by days in a table?
Forum Posts
How to make a filter mandatory?
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?
How to call Python dataframe output in Sisense Notebooks to use as an input in other blocks.
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.
Blox Date gran for different week start day
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...
Resolved! How to Calculate YTD by Month in a pivot table
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...
While building a data model I encountered this error ElastiCube error. Error details: BE#184269 Fail
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...
Widget Scripts UX
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...
Resolved! Edit Widget Script Sisense to display NA for specific condition
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...
Resolved! Advanced Filter Function
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...
"Where" Function
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...
Format data labels
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 ...
Lookup Limited to Rows without a Null Value
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 Formulas referencing one table
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...
Adding a column with no aggregation
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()...
Jump to Dashboard - Date filter is added twice
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...
