Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Can't filter/sort on calculated columns

Answered
Patrick Berens asked on September 14, 2020

Hi ya,
Our customers would really love to be able to filter and sort on calculated columns.
 
Is that on the roadmap anytime soon? We are using Flexmonster json data version.
Thanks,
Patrick

6 answers

Public
Vera Didenko Flexmonster September 15, 2020

Hello, Patrick, 
 
Thank you for writing to us. 
 
Our team would like to explain that calculated values can be sorted and filtered in Flexmonster just like other value Fields. 
Please see the following JSFiddle for illustration: https://jsfiddle.net/flexmonster/a872pt91/
In the provided example, the "My Calculation" calculated field is sorted in ascending order and the values are filtered to include only those that are greater than 1000000. 
 
Please let us know if this works.
 
Kind regards, 
Vera

Public
Patrick Berens September 15, 2020

Thanks Vera,
 
You are right, it does appear to work for Pivot View. But our customers need it for Flat View. Is that possible?
Thanks again,
Patrick

Public
Vera Didenko Flexmonster September 16, 2020

Hello, Patrick,
 
Thank you for your reply. 
 
Our team will add support for sorting calculated values in flat layout. 
This update will be available in the minor release version with the ETA 19th of October. 
 
As for filtering calculated values in flat layout, we have added your request to our customers’ wishlist. We will notify you in case of any updates on the matter. 
 
Please feel free to contact us in case questions arise in the meantime.
 
Kind regards, 
Vera

Public
Vera Didenko Flexmonster October 20, 2020

Hello, Patrick, 
 
We are happy to inform you that the sorting functionality was enabled for calculated measures in the flat form.
 
This is available in the latest version of Flexmonster: https://www.flexmonster.com/release-notes/.
You are welcome to update the component.
 
 
Please let us know if everything works fine for you.
Looking forward to your feedback.
 
Kind regards,
Vera

Public
Vera Didenko Flexmonster October 26, 2020

Hello, Patrick,

Our team is wondering whether you had some time to test the introduced feature.

Looking forward to your feedback.

Kind regards,
Vera

Public
Vera Didenko Flexmonster November 2, 2020

Hello, Patrick,
 
Our team is wondering if sorting for calculated measures (in flat form) works fine for you. 
Please let us know if everything works.
 
Looking forward to your reply.
 
Kind regards, 
Vera

Please login or Register to Submit Answer