This content has been marked as final. Show 2 replies
I am trying to create some charts that show trending over time.
The way I currently have my file setup is that each week a new file is generated, this file is a snapshot in time of the data. I have my script convert the file to a QVD and store it into a folder. It then reloads the QVD and uses this for all of the current-week dashboards. However, I also have a trending dashboard that I've created, which goes through and loads the past weeks data to use for trending. These files are optomized QVDs and only have the necessary information, however, they are still fairly large files and as each week goes by more and more of them are being loaded. I really only want to load about 6 of them and I have them named in the following convention: 'XXXX_20110530.qvd'.
Is there a way that I can only load the most recent 6 or so qvds that I have stored?
Please let me know if you need any more information.