☝️Small business or a startup? See if you qualify for our special offer.
+

Values that are of type 1+- 0.1 are not correctly used to calculate average/aggregated values

Resolved
Nikita asked on August 18, 2025

When we have such values: 1+-0.1 or 2 +- 1, etc. that consist of 2 numbers, Flexmonster does not calculate correct aggregates: data.label in CustmizeCell function is incorrect (you can see average is 7.7333 which is incorrect given the individual numbers in parentheses. Flexmonster is treating 2 +- 1 as 21): 

Raw data field value that we provide for the Flexmonster:

We wonder if its just Flexmonster limitation and we should never use such numbers or there is a workaround.

1 answer

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster August 19, 2025

Hello,

Thank you for reaching out to us.

Flexmonster does not support the described number format. If you want to display such numbers, we recommend defining the field's data type using mapping as "string". For example:

mapping: {
"pktest/t2/2": {
          type: "sting",
    },
}

You are welcome to check the following JSFiddle for reference: https://jsfiddle.net/flexmonster/rqofcyvL/. Kindly note that only count and distinct count aggregations are available for string fields.

Please let us know if it works for you. Looking forward to hearing your feedback.

Kind regards,
Nadia

Please login or Register to Submit Answer