Is there any way to add a select filter and a value filter. For example: I want to filter where the date is in (2024-05, 2024-06) AND the sum of value is greater than 0. I can do each on its own but I don't think I can combine the two at the same time. I included screenshots of the two filters I would want.
Hello,
Thank you for contacting us.
Currently, Flexmonster only allows setting multiple filters in the report. With this in mind, to add both the select and value filters, you can predefine them in the report object. You are welcome to check the following JSFiddle for illustration: https://jsfiddle.net/flexmonster/kehsorp4/.
Please let us know if it works for you. Looking forward to hearing from you.
Kind regards,
Nadia
Hello,
Hope you are doing well.
We were wondering if you had a chance to check the suggested approach. Could you please confirm if it works for you?
Looking forward to hearing your feedback.
Kind regards,
Nadia
Nadia,
Thanks for the suggestion but I don't think this will work for us since we want our users to be able to dynamically add/update/remove these filters so hardcoding it on the report object isn't an option for us.
Thanks,
Brian
Hello Brian,
Thank you for the response.
We agree that having combined select and value filter support directly from the UI would be a great improvement. We are happy to share that in Flexmonster 3.0, our team has already implemented filtering combinations, including member filters alongside multiple conditional filters. You are welcome to explore this feature on our demo: https://prerelease.flexmonster.com. Support for value filter combinations is also planned for future releases.
In the meantime, as a workaround for your current use case, you can build a custom filter control using Flexmonster API calls. This allows users to dynamically set and update any combination of member and value filters at runtime. You can use the following events and API calls:
Do not hesitate to contact us if any questions arise.
Kind regards,
Nadia