creating a trend line

[Anonymous]

I want to create a trend line of open defects over time (days). Everyday the SQL query would pull up the list of open defects from the DB. Say it found on Apr 25, 14 defects are open. When the query ran on Apr 26, it found 9 defects open.

My issue is after the pulling in the table (Say DefectsTable) of data from DB everyday, how to keep it in segregated form datewise. My DefectsTable will be overwritten everyday once the report refreshes. In such cases, how to keep the numbers from previous days intact to build the trend line.

[Ashish_Mathur]

Hi,

There is no way.  If you want to analyse data over time, records of those previous timeperiod will have to be present in the table with a date column.