I have a line chat with month year as x axis. y acids is a percentage.in the data set I have date as month year, amount to show as percentage and an additional text field. I want the chat to plot out the percentages with point labels that instead of using the amount as a PerCentage, cognos show s the text, but aligned at the proper y axis position as per the amount percentage.
any thoughts
Hi Jim,
Can you explain in more details?
I not clear with the requirements.
Reagrds,
Rahul
Let me ask it two different ways. Basically, I want a chart of percentages by month/year. M/Y is X-Axis, Percentage is Y-Axis.
I want each point on the graph to say not only the % values, but but also an annotation. I understand markers and notes, but haven't been able to get those to work programatically through the query, having multiple markers/notes. That's question 1 - how do you assign a number of markers - one per data point on the graph?
The original question - let's say I have the structure:
MonthYear as integer
Percentage as float
Annotation as varchar(64) (can = NULL)
I plot the chart using MonthYear and Percentage as value. I want, instead of the value of Percentage shown, then field Annotation.
For example, if one datapoint is:
MonthYear= 201301
Percentage = .5
Annotation = 'Testing'
I should see a graph point for 201301, 50%, but it won't sway 50%, it will say 'Testing', but at the vertical position where 50% would be.
Does that make more sense?