Hi
I have a chart that shows Actual for each months starting from previous Fiscal Year and up to current months in this fiscal year. (Fiscal Year Starts in March)
The requirement is to show a marker on the current month and Previous year current month.
How do I achieve this ?
Some More information :
Environment : Cognos 10.2.2
Relational Model
Report Studio
Chart Type : Clustered Smooth Line
Since the marker index needs to be dynamically calculated depending on the number months we have data for.
I was trying to do some calculation with Category Position using Layout calculation but every time I tried this it throws an error saying :
"RSV-VAL -0032 The following expression if ([MonthlyTrend].[Marker1] >0 ) then (10) else (0) is not valid. If the item exist in but not referenced
in the layout , add it to the property list."
But for a chart there is no properties list and I am not sure why I am getting this error message.
Below are the available options to use when it comes to markers in Cognos:
Number Position : Query Calculation
Data Item Value : Marker1
Category Position : 1) Layout Calculation
2) Category Indexes
3) Percent on Axis
Which of the above property should I be using ?
Hi,
You can set the properties on the x-axis nodes of the graph. See if this helps. Create a data item a 'if ([MonthlyTrend].[Marker1] >0 ) then (10) else (0)' and add that data item as the property.
Good luck
New guy