Note: We are actively completing a knowledge migration process. This space will grow over the next few months as this work is completed.
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

List Of Date Format Conversions

Question A date stored in a source system is not a datetime that Sisense recognizes. Converting it to a Sisense datetime allows powerful front end capabilities (such as drill down, quick functions and more). Answer Julian AddDays(CreateDate(1970,1,1)...

Get ElastiCube from Process ID

Question I would like to be able to track memory consumption of my ElastiCubes, but I can't find an easy way to link the process ID of my ElastiCube to the cube name. Answer If you open the Task Manager, go to the Details tab and right-click on one o...


Consortium Data By Masking Sensitive Values

Question Some organizations provide Sisense to their clients as part of their business offering. Some of these organizations would like also to provide clients with the consortium data derived from Sisense - a single ElastiCube where clients submit t...

Community_Admin_0-1634390318706.png Community_Admin_1-1634390318600.png Community_Admin_2-1634390318620.png Community_Admin_3-1634390318581.png

LAG / LEAD Functions

Question LAG & LEAD Functions are functions that give access to multiple rows within a table, without the need for a self-join. The LAG function is used to access data from a previous row, while the LEAD function is used to return data from rows furt...

Community_Admin_0-1634389201706.png Community_Admin_1-1634389201499.png Community_Admin_2-1634389201175.png Community_Admin_3-1634389201530.png

Lookup With Two Conditions

Question How to do a lookup using two conditions (i.e., pulling project number on a unique equipment for a specific day)? Answer You can only use one field as the key field in Lookup function. So, it is better to create a combined key (using concat o...

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?