Hello Team ,
We are using open source BI Helical Insight enterprise edition version 5.1. In that I am looking to set a filter for a date field from 01-01-204 to Today. So basically there are 2 conditions. Could you please help us with to achieve this.
When We tried with Today, the date filter is showing to 09-01-2025 to 09-01-2025.
Let me know if you need more information.
Thanks,
Netta.
Hello ,
For your scenario, you need to create two filters:
The first filter should use a ‘greater than or equal to’ condition with the hard-coded date ‘01-01-2024.’ This filter you can keep as hidden so that users do not see it via using the Advanced options which appears when you hover over the filter.
The second filter should use an 'end date less than or equal to’ condition with today’s date by making use of relative date filter functionality.
Relative date usage filter : Relative Date Usage - Helical Insight
Hiding filter: Filters Advance Mode - Helical Insight
Thank You