Skip to Content
author's profile photo Former Member
Former Member

Change number format of chart axis values

Hello everybody,

First of all I'm a newbie in designing Web Intelligence Reports. 😉

Currently I try to design a report with a universe based on a SAP BW query as the datasource. In the report there is a chart where I want to change the format of the X Axis values. The X Axis consist of two dimensions: Date (dd.mm.yy) / quarter of the hour of the day (a number from 01 - 96). In the Chart properties under Appearance --> X Axis --> Values --> Number format I can just change the number format of date. The second dimension quarter of the hour can't be changed. My goal is just to show the date without the second part. Is there a way to achieve this?

Regards,

Chris

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 28, 2010 at 03:05 PM

    Sorry, probably I did not express clearly what I want to do. The values in the chart look like they should. I just want to change the labels below the X axis.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 28, 2010 at 08:34 AM

    .

    Edited by: Alok Gupte on Oct 28, 2010 2:06 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 28, 2010 at 08:34 AM

    .

    Edited by: Alok Gupte on Oct 28, 2010 2:07 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 28, 2010 at 08:34 AM

    .

    Edited by: Alok Gupte on Oct 28, 2010 2:10 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 28, 2010 at 10:30 AM

    Hey Chris,

    My goal is just to show the date without the second part. Is there a way to achieve this?

    Create Variable in BO WebI Report which will subtract that Quarter part and give you only Date part.

    Now use this Variable in place of existing for Chart.

    Use Substr(), trim() etc..., functions to get exact data.

    Gracias...!!

    Let's play with Aurora (BO XI 4.0)

    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.