X-axis value not getting in line chart

[Former Member]

Hi All

I'm working in SAP xMII 11.5. I have a doubt in line chart. In my work , i need to populate the graph based on the input given by the user. I'm getting that. I have time as scale value in X- Axis. How to set time value from 0000hrs to 2400hrs. Its not coming. Please help me. I have tried giving in x-axis value in display template. Yet i'm not getting that.

Thanks

Vinodh

[Former Member]

Hi Vinodh,

I'm not sure exactly what you mean - do you want the X-Axis labels to read exactly 00:00 01:00 02:00 ...... 24:00?

What input is coming from the user? Is your query time-based?

Kind Regards,

Diana Hoppe

[Former Member]

Hi Diana

Yes. I'm plotting a line chart. I'm having production in units alongy-axis and i did it. I want to have time along x-axis. I dont know how to set this time as 0000, 0100, 0200, 0300, 0400.........2200,2300,2400hrs. I hope you got my requirement clear now. The user gives the production units as input. I'm fetching the time and with that time i'm plotting against production units entered.

[Former Member]

Hi Vinodh,

I have some suggestions for you to try, based on my own experimentation, using a tag query in History Mode.

For the Query:

If you want a single value for each hour of the 24hour period, set the RowCount to 24 the Duration of your query to 24 Hours. In the Time field, type Today@00:00:00. I'm not sure how the user will be choosing a start and end date for the query, but, doing this way seems to allow the user to scroll using the VCR-type controls on the iChart, and the times hold the the same format (always ending in 00:00, which you will configure in the Display Template).

For the Display Template:

On the General tab, make sure the Use Screen Resolution property is unchecked.

On the X Axis tab, the Date Format field should be empty. Change the Time Format to HH:mm. Also, set the following properties on this tab:

Major Tick Count: 12

Minor Tick Count: 0

Ticks Per Label: 1

Label Font: you may want to change this to a smaller font.

Note: I found it impossible to display all 24 hours on the iChart. The above settings should give you 2-hour increments.

I don't know if this will solve your problem, you have to play around with these properties, but maybe this will give you a better idea how they work.

Kind Regards,

Diana Hoppe

Edited by: Diana Hoppe on Feb 3, 2011 12:13 PM