Skip to Content
0
Former Member
Jan 19, 2011 at 02:49 PM

Record that span multiple time periods - how to graph counts

37 Views

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