Get Free Trial

Problem with distinctcount

Answered
Artsem asked on October 3, 2022

Hello support team,
Facing a problem:
when created a Calculated value with distinctcount measure and then deleted from FlexMonster this measures, so we got a problem(1.png), but if we used another aggregation – it was worked

Attachments:
1.PNG

8 answers

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster October 3, 2022

Hello, Artsem!
 
Thank you for contacting us. 
 
Our team has made some assumptions about the described case:

  • there are two calculated measures;
  • the first measure is used in the formula of the second one;
  • the second measure has distinctcount aggregation;
  • we are trying to delete the first one while the second remains on the Field List.

 
We have also prepared the JSFiddle sample with the behavior described above: https://jsfiddle.net/flexmonster/urca6vxh/
 
Could you please check the example and tell us if we have reproduced the described case correctly?
If not, we kindly ask you to modify the example to make the case reproducible.
 
 
Looking forward to your response.
 
Kind regards,
Solomiia

Public
Artsem October 4, 2022

Hello Solomiia,
I reproduced this problem 
https://jsfiddle.net/k64g972e/
We used options.validateFormulas = false
But if you change the formula on “count”(or another aggregation) information is shown

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster October 5, 2022

Hello, Artsem!
 
Thank you for getting back to us and for the JSFiddle where the case is reproducible.
 
Our team will take a look at the described behavior and remove the exception thrown for distinctcount aggregation created with non-existent measure when the formula validation is disabled. The fix will be available in our minor release with the ETA October 31th.
We will notify you about any updates on the matter.
 
Our team also kindly recommends to enable the validateFormulas option to avoid possible issues with the calculated values.
 
Feel free to contact us in case of any other questions.
 
Regards,
Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster November 1, 2022

Hello, Artsem!

Hope you are doing well.

We are glad to inform you that the exception when using aggregation over non-existent measure in calculated values was fixed.

This fix is included in the 2.9.37 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-37/.

You are welcome to update the component.
Here is our updating guide for reference: https://www.flexmonster.com/doc/updating-to-the-latest-version/.

Please let us know if the fix works well for you.

Regards,
Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster November 9, 2022

Hello, Artsem!

Hope you are doing well.

Our team is wondering if you had some time to test the fix.
Could you please let us know if it works for your case?

Looking forward to hearing from you.

Regards,
Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster November 17, 2022

Hello, Artsem!

Hope you are having a great week.

Just checking in to ask if the fix with distinctcount works well for you.

Looking forward to hearing your feedback.

Regards,
Solomiia

Public
Artsem November 17, 2022

Hello Solomiia,
 
Sorry for the long answer.
While we have not updated, how will we do it and if there is a problem, we will write to you.
Thanks for your time!
 
Best regards,
Artsem

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster November 17, 2022

Hello, Artsem!

Thank you for getting back to us.

Your feedback is valuable to our team, so we’ll be waiting for the following updates on the case.

Feel free to contact us if any other questions arise.

Regards,
Solomiia

Please login or Register to Submit Answer