Formatting Axis Tick Values Based on the Underlying Data

Andrew Clauson shared this question 19 days ago
Answered

I have a line chart plotting percentage values. I can set up the view field, the report builder, and the chart tooltip to display these correctly (i.e. show 10.00% instead of 0.1). However, the chart's Y axis doesn't appear to inherit these settings - it only shows the numeric result.

Adding a "%" suffix to the axis tick values doesn't solve the problem, as it doesn't move the decimal place (per the example above, it would show 0.1% instead of 10.00%).

I've also tried the "convert" option on the field at the view level (numeric divide by 0.01) in an attempt to effectively multiply the field value by 100, set it as a numeric, then add a "%" suffix. That doesn't work either; not in the report builder, and not in the axis formatting settings in the chart builder.

I realize a "solution" to this problem is to create a calculated field that multiplies my target field by 100. However, I have a large number of percentage metric fields, so this would be a) very time consuming and b) create a lot of confusion for users in the report builder as to which field they should use.

Is there any other way I can accomplish this?

Comments (3)

photo
1

Hi Andrew,


Thanks for your question.


You should be able to get the result that you are after by using one of the Advanced Functions, Percentage against ...


/a5678016696b0b54fa0a6a9a57b74045


Let me know if this gets the results that you are after.


Kind regards,

Simon

photo
1

Thanks, Simon. I’ve figured out how to get the “convert” approach working by turning off aggregation for the metric at the report level. This has solved my problem for now.

Andrew

From: Yellowfin Support <support@yellowfin.bi>

Date: Sunday, March 28, 2021 at 10:33 PM

To: Andrew Clauson <andrew@profinancial.bc.ca>

Subject: New Comment in "Formatting Axis Tick Values Based on the Underlying Data"

photo
1

Hi Andrew,


I'm glad to hear you figured out an alternative!


Please don't hesitate to reach out if you require further assistance, and I will get back to you shortly.


For now, I will go ahead and mark this as answered.


Kind regards,

Simon