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.
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