i have to create a report in an angular application with default date filter applied to last 90 days. Now can i use “last quater” filter or have any other method to have last 90 days filter to date column dynamically
Thank you for writing to our forum.
It seems that the
last quarter filter is the most suitable for this scenario. Also, you are welcome to check our docs where all date filters are described: https://www.flexmonster.com/api/date-query-object/. The same filters are also available in the UI.
Please let us know if any further questions occur.
Adding more details to my initial reply, I would like to clarify that although the
last filter is dynamic, it is not a direct equivalent of the last 90 days. For instance, since now is the Q1 of 2021, the last quarter is Q4 2020.
Another dynamic filter that may be useful in this situation is
current. However, to show the last 90 days, we suggest setting the needed date explicitly before loading the report into the component. Please let me know if you need more details on this approach.
Thank you for your response. I am planning to use last quarter. But i am facing problem. I am using flexmonster with elasticsearch. And for date type data i am not able to apply date filter with “Last” anything. i.e i am able to filter date data by other parameters like equal, before , after and so on but when I try to use last date filter with any value like last quarter, last month etc it is not working when i check _search post request it is sending empty post data as in the screenshot attached
Thank you for describing the issue in detail.
Our team noticed your new question related to this issue on our forum.
Please see the answer following this link.