Chart Axis Summary and Prefix/Suffix not possible

lien.hoang shared this idea 35 days ago
Idea Logged

Hi,

I have a report that I need to create that would need to show both the summaries metric value and the prefix/suffix the metric at the same time.

Currently, you can only have one or the other, and the only way to avoid this is to create a calculated field to summarise the metric before it is added to the chart.

Would it be possible to allow for both these options to apply at the same time?

Attached are some screenshots of the process to replicate the issue. This includes a chart with a summarise vertical axis and another chart with the custom option (to show prefix/suffix).

I have also attached an example exported report.

This was tested on 9.4.1 20121216.

Comments (1)

photo
0

Hi Lien,


Thanks for your message.


Unfortunately, the behaviour you are after is not currently possible using the formatting options. You should be able to get a similar result by altering the original column value using a Calculated Field (for example dividing the column by 1000) and then using that in the Chart instead, in order to add a prefix/ suffix.


I have gone ahead and raised an Enhancement Request on your behalf, and I will change this ticket type into a public Idea post so that others can engage with the post. Enhancement Requests are assessed by a variety of criteria including community engagement and impact to users.


Let me know if you have any further questions, I will update this post with any changes with regard to the Enhancement Request process.


Kind regards,

Simon