How-Tos & FAQs
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

How to create a list of users with a current role

How to create a list of users with a current role To get a list of the users with their roles you can use table usage. Get the next fields from it - email and userRole. In this table, you can find all the roles that these users had previously   [ALT...

OleksandrB_0-1742578413500.png OleksandrB_1-1742578413516.png OleksandrB_2-1742578413509.png OleksandrB_3-1742578413513.png
OleksandrB by Sisense Team Member
  • 105 Views
  • 0 comments
  • 1 kudos

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 fur...

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