Skip to Content

Changing content of x axis labels

Hi Community,

Some Background: We have plenty of pre-built reports which we need to adapt and translate (English to German) for our organization. Some of them use line and / or bar charts. We can't figure out how to change the x axis lables in a productive way:

To achieve the "24:00" i had to change the formula fields name from @Chart_12PM to @Chart_24:00, then switch to the preview tab, right click the label, change the value manually to 24:00, adopt to layout and save. This means I have to do this for 24 labels. Is there any way to change the names in the diagram assistent:

Doing this in the preview tab seems really static and like a lot of work. The "Summe von" (Sum of) part is not needed.

Thanks & Best rergards

chart-axis.png (20.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Oct 05, 2018 at 02:26 PM

    Hi Stefan,

    Since these summary fields represent each 'value' on the x-axis, you'd need to manually change them.

    You should instead use a 'time' dimension in the 'On Change of fields' and a single summary in the 'Summarized fields' section. This way you can control formatting of the time stamp.

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.