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 ?
Quote from: R Ambre on 15 Nov 2018 03:19:28 AM
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.
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
Quote from: R Ambre on 16 Nov 2018 04:08:51 AM
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.
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?
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.
@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