According to this document：https://docs.eazybi.com/display/EAZYBI/Date+filters
I used the :**beginning of last month and first day of current month**,The result is correct
But if I want change current month like below , I can’t get correct result,I don’t know why;
beginning of current month and first day of next month
I checked a similar filter but used the “first day of current month” instead of the “beginning of current month” and it seems working fine.
There are a couple of things to check for such filter to work:
- The expression “beginning of current month” is working differently than “first day of current month”. EazyBI uses the Chronic library for parsing such expressions, we recommend trying out more advanced expressions before using them in filters by creating custom measures like this:
DateParse('beginning of current month')
The measures should show how the parser will interpret the expression.
- As you are trying to filter time dimension members for the future, there might be none of them currently in your data. Please, try generating them manually (see the screenshot).
Janis, eazyBI support
I try to do something similar but I cannot get it to work, unfortunately:
I want to change all our dashboard to dynamically only go like for example 2 years back.
But we need always full months for the (monthly) graphs being correct.
For the Import JQL it already works great … *AND (resolution = Unresolved or resolved >= startOfMonth(-24))
Now I only need to have the charts correct.
I use the chronic expressions from https://docs.eazybi.com/eazybi/analyze-and-visualize/date-filters and https://github.com/mojombo/chronic#examples
I tried something like between
first day of 24 months ago and now
beginning of 24 months ago and now
The first one does not work at all (empty graph) and the second one seems not to use the beginning of the month.
I would expect it goes back to 1. July, but it does not
Do you maybe have an idea what I do wrong or if there is a way to do it? I also could not find more information on the chronic syntax
Big thank you in advance.
Best regards, Markus