Consistent range on x axis for time in chart

[R Ambre]

Hi,

In my project we have requirement to show timestamp on x-axis and amount on Y axis for selected date.
Now user wants Consistent range on x axis for time for e.g. 6 AM to 9 PM as default minimum and maximum value and consistent interval .

I am not getting Axis Range option when I am clicking on X Axis.

Can somebody help me on this ?

[Lynn]

Hi,

In my project we have requirement to show timestamp on x-axis and amount on Y axis for selected date.
Now user wants Consistent range on x axis for time for e.g. 6 AM to 9 PM as default minimum and maximum value and consistent interval .

I am not getting Axis Range option when I am clicking on X Axis.

Can somebody help me on this ?

Chart properties can vary across different chart types. Why not provide a little more information so that you get better answers? For example, how about specifying which chart you are trying to use? Perhaps use the samples to mock something up and post the XML here so someone can quickly point you in the right direction? Knowing which version of Cognos you are using is also worth mentioning.

[R Ambre]

Thanks Lynn.

We are using 10.2.1 version.
I am using combination chart where chart type is line.
We have some amount on Y axis ,Time on X axis and category on Series.

Query is very straightforward.
Date TIme
Amount
Category

Filter on Date

Please let me know if you need more information

[Lynn]

Thanks Lynn.

We are using 10.2.1 version.
I am using combination chart where chart type is line.
We have some amount on Y axis ,Time on X axis and category on Series.

Query is very straightforward.
Date TIme
Amount
Category

Filter on Date

Please let me know if you need more information

The x-axis is expecting a category for that type of chart, not a measure. The axis range property has to do with measures, not categories.

You should be able to control what categories are displayed by ensuring your query returns all the desired categories.

[Invisi]

How about adding a filter to your query so that your times are in the range you want? Or is it that your time range is smaller than what you mention as start and end time?

[khabaleshri]

If legacy chart option is enabled then you need to disable it from Tool-Option-Advanced and highlight primary axis  properties-general- Axis range and define maximum and minimum values.

[R Ambre]

@Invisi     My report is based on live data and we have fixed start and end time need to shown but If user enter records lees than start time then chart should be flexible enough to accomdate that
@khabaleshri I tried this option and I am not getting option for Axis range