I am tasked to create a report that provides a graph that shows trouble report (TR) history, i.e. the number of reports open over time, in 1 week intervals. The problem is that trouble report are open over months or years, so they must be included in the count over many weeks. I can easily the total number of reports written over time.
Each TR has the following data: ID, submit date, close date. I can not graph the data as I need to assorting on the dates does not give me the information that provides a true reflection of the data. I did create a global variable to gather the data, but there again it doesn't not provide the date axis data I need. Any ideas how to do this in CR? Thanks! Helen
ex
ID submit closed
100 8/8/10 12/12/10
101 8/15/10 NULL
102 10/10/10 10/31/10
103 10/20/10 NULL
open counts
8/8 - 8/14 1
8/15 - 10/09 2
10/10 - 10/19 3
10/20 - 10/31 4
11/1 -12/11 3
12/12 - present 2