Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

Calculate Pivot Total at Row Level

Analytical Need  Calculate the pivot grand total at the row level to do calculations such as % of the grand total. You may have tried the following and not received the desired results: ALL function This will ignore your row groupings, which is what...

Community_Admin_0-1634205398347.png Community_Admin_1-1634205398519.png Community_Admin_3-1634205398745.png Community_Admin_4-1634205398743.png

Exclude 'today' using jaql

Sometimes we'd like to see all our data up to today, not including. It is very easy to achieve this within the Elasticube by creating a custom column which calculates the daydiff between the date to today i.e. daydiff(now(),[date_field]) and then fi...

Community_Admin_0-1634204497801.png Community_Admin_1-1634204543065.png
Labels