How to show 2 decimals in Chart with average aggregation type?

0
Hello   I have a graph with some integer and an aggregation type: average. I works fine but the average value shows 7 and more decimals... How can I configure the graph to show only 2 decimals (for example 2.12 instead of 2.123654789)?
asked
2 answers
0

You can set the formatting using advanced chart configuration. In the chart, select mode “advanced” then in layout options box, provide JSON containing plotly layout options. 
For your case, you need to set the tickformat of your axis to “%2f” for two decimal places. See the plotly reference here
https://plotly.com/javascript/reference/layout/xaxis/#layout-xaxis-tickformat

For usage and syntax, see Mendix advanced chart cheat sheet
https://docs.mendix.com/refguide/charts-advanced-cheat-sheet

answered
0

I tried to do it:

I added:

{
  "yaxis": {
    "tickformat": ".2f"
  }
}

in the advanced tab of my chart; the Y-axis label has now a 2 digits precision but not the values of the data...

answered