cancel
Showing results for 
Search instead for 
Did you mean: 
Community_Admin
Community Team Member
Community Team Member

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 filter that dimension by excluding the '0' value, though this will require us to add a complete column for every row in this table, which can be redundant. Instead, we can do this using JAQL as an advanced filter.

In order to achieve this, create the filter on the days' list picker, then, without selecting or un-selecting a day:

Community_Admin_0-1634204497801.png

Then, go to the advanced tab and paste the following jaql:

 
{
 "explicit": false,
 "multiSelection": true,
 "exclude": {
 "last": 1,
 "offset": 0
 }
}
 

You can test this to validate the query is indeed returning all days except from today

Community_Admin_1-1634204543065.png

After achieving this filter, you can star this filter, and use it for additional widgets or measured values.

Download:

excludetoday.ecdata

excludetoday.dash

Version history
Last update:
‎10-14-2021 02:43 AM
Updated by:
Contributors
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?

Email [email protected]

Share this page: