asked on November 26, 2021
Hi support team,
In https://www.flexmonster.com/question/apply-conditional-formatting-for-separate-metric-aggregation/ my coligue asked for feature related to separating conditional formatting for same metric with different aggregation. But can same logic be applide for formating carrently? I mean can I set different format(e.g. decimalSeparator). Currently, when I try to set different format field to measures objects it overriden by the value from last measure for every measures.
If it possible Could you, please, explain how it can be done or provide any plans on that? Can it be done by the feature request in previously mentioned topic?
Regards,
Uladzislau
⋅ November 29, 2021
Hello, Uladzislau,
Thank you for writing to us.
You are right; currently, you can apply only one number formatting rule per measure. We have added the request for formatting each measure's aggregation separately to our customer's wishlist. We will inform you in case of any updates.
In the meantime, a possible solution is to wrap each aggregation in a calculated value. This way, you could apply different number formatting rules to each aggregation. For example:
measures: [
{
uniqueName: "Price Average",
formula: "average('Price')",
caption: "Price (Average)",
format: "average"
},
{
uniqueName: "Price Sum",
formula: "sum('Price')",
caption: "Price (Sum)",
format: "currency"
}
]
Here is a JSFiddle for illustration: https://jsfiddle.net/flexmonster/06bxhre5/.
Please let us know if this works.
Looking forward to your response.
Kind regards,
Vera
⋅ November 30, 2021
Hello Vera,
Thank you for quick answer. Unfortunately, this solution will not work for us. We will wait for feature implementation.
Regards,
Uladzislau
⋅ November 30, 2021
Hello, Uladzislau,
Thank you for your response.
Our team will inform you as soon as the feature is available.
As always, feel free to contact us if other questions arise.
Kind regards,
Vera
⋅ January 24, 2022
Hello, Uladzislau,
We are happy to inform you that now it is possible to set different number formatting for measures with different aggregations.
This is available in the latest (v2.9.17) minor release version of Flexmonster.
You are welcome to update the component. Here is our updating to the latest version guide for assistance.
Please let us know if the new feature works well for you.
Looking forward to your feedback.
Kind regards,
Vera
