Hi DOJO
I am tring to filter a GQI with a date that is greater than or equals to the first day of this month.
Today is april 28th so the result should automated give: 01/04/2025
I tried with time range component, set to this month, and it seems OK
What would be the best way to achieve this, without action from the users and without to see the date range component ?
Hi Joel,
The easiest way to achieve such a filter is using the time range component, as you mentioned. This means that the component will be present on the dashboard, which can be a downside in some cases.
As an alternative, you could write a custom operator to act as a filter. Note that this operator will act as a post-filter and will not be forwarded to the database. This could have a significant performance impact when compared to the native filter nodes.
The last option is to write an entire ad hoc data source to do this for you. That way, you have full control over what data is fetched which is good for performance. The downside here is that this can be a lot of work to implement and is very specific for this use case.
Thank for your reply Mahieu
OK, I keep the time range component with a grid size of 1X1.
An other way I tried, was to use a time range component in a hidden page, but the date returned is 01/01/1970 🙁