We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

Filter by values works incorrectly when measure is used several time with different aggregations

Answered
Andrei asked on January 24, 2022

Hello!
We have faced a filtering issue when the same metric is added a few times with different aggregations. Filters for non-first aggregation do not work as expected. Here are some examples:
https://jsfiddle.net/sw4q1hk7/2/
https://jsfiddle.net/sw4q1hk7/3/
You can see that records are hidden, even so, totals are shown. If you reset filters you can see that there are records satisfying configured filters. The same behavior exists if filters are applied from UI.
Thanks,
Andrei

4 answers

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster January 25, 2022

Hello,
 
Thank you for reporting this issue.
 
We will provide a fix in the minor release with the ETA March 7th.
You can create a calculated value based on the necessary measure as a temporary workaround, and filters will work as expected. Please check the following JSFiddle for reference: https://jsfiddle.net/flexmonster/3c8ab6k1/3/
 
You are welcome to write to us in case further questions arise.
 
Kind regards,
Nadia

Public
Andrei January 25, 2022

Thank you, Nadia!

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster March 8, 2022

Hello, Andrei,
 
We are pleased to inform you that the issue with filter by values when there are measures with different aggregations was fixed.
 
This is available in the 2.9.20 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-20/
 
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/ 
 
Please let us know if any questions arise.
 
Kind regards,
Nadia

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster March 15, 2022

Hello, Andrei,
 
Hope you are doing well.
 
We were wondering if you had a chance to test the fix. Could you please confirm if everything works well for you?
 
Our team would be grateful for your feedback.
 
Kind regards,
Nadia

Please login or Register to Submit Answer