Hello,
I have attempted to build a line graph through cognos report studio, youtube and several google posts and am having trouble. It is not showing my closed defect data and it is not filtering the total requests
Requirements:
1. Line graph that shows total requests as the Y axis. Total requests opened or closed on that specific date as each a line. ie open has a line on the graph, closed has a line on the graph
2. I also need a possible third data item(custom) perhaps to show total (both open and closed) as another line on the graph
What I have done:
1. I created a line graph with total requests as Y axis. I selected series as "request status" . I selected "date" as x axis based off of a canned dashboard report I found.
Detailed Filters:
caption([Request Metrics].[Type].[Type].[Type])in ('Defect','defect')
[Project Name]='xx'
caption([Request Metrics].[Request Status].[Request Status].[Request Status])in('Open','Closed')
[Team Name]='/xx
cast ([Creation Date], date) = current_date or cast([Resolved Date],date) = current_date'
Problems:
1. It is showing only 2 opened defects, when I have many more that were opened on that date of 4/7/14
2. Also it is showing no closed defects on the graph
It looks like you have a dimensional source which means that detail filters are a bad idea. This post has some EXCELLENT information on the subject: http://www.cognoise.com/index.php/topic,24931.0.html