Get Free Trial

Apply formatting for separate Metric + Aggregation

Uladzislau Chernik asked on November 26, 2021

Hi support team,
In 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?

3 answers

Vera Didenko Vera Didenko Flexmonster 6 days ago

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:
Please let us know if this works.
Looking forward to your response.
Kind regards,

Uladzislau Chernik 6 days ago

Hello Vera,
Thank you for quick answer. Unfortunately, this solution will not work for us. We will wait for feature implementation.

Vera Didenko Vera Didenko Flexmonster 5 days ago

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,

Please login or Register to Submit Answer