How to use the NOW function from Insights

News Knowledge Base
,
1

How to use the NOW function from Insights?

Issue :

Now function from Insights does not bring proper values when applies

Solution :

Apply an advanced filter on the date field. See screenshot below:

![](upload://kJwOg64k5BSqXpY01ZUfH3Hz3aS.png)

To get everything up until and including the current month, it will be:

{

"last": {

"count": 10000,

"offset": 0

}

}

If the desire is do not want to include values for the current month please change the offset to '1'

{

"last": {

"count": 10000,

"offset": 1

}

}

Note: set the count to 10,000. This will give them data going back 833 years (so essentially all dates in the data set). This number can be manipulated further to return the desired number of months. Please be advise of not going higher than 10,000 as it will time out.