On 6/29/2009 4:22 PM, Patrick Fowler wrote:
It's there a way of getting an average utilization over a certain amount of
time from the graphs created in InterMapper? I've been asked by my Higher Up's
to provide metrics on a weekly basis. Graphs are cool but they like numbers.
Or is there a way to export the data for those link and time periods into excel?
Hi Patrick,
You have two options for exporting this data so that you can get an
average for utilization over a period of time.
One is to export the chart data to a text file, which you could then
import into Excel. This is quite simple. Open the Chart Options > Data
window, select the variable you wish to export, and click the 'export'
button. You can only select one variable at a time to export, so this
would be a rather cumbersome process if you wanted to export many
variables for many charts.
Another option is to export the data to the InterMapper Postgres SQL
database, which would then provide you with greater flexibility in
reporting on the data via SQL queries. However, until InterMapper
Reports is available, you will need external tools to retrieve data from
InterMapper Database via SQL. To get you started, we've written several
short example reports in Crystal Reports and OpenRPT, as well as several
example perl scripts.
This tech note provides much more detail as well as links to the sample
scripts:
http://www.intermapper.com/tech-notes-database-a-datacenter/191-intermapper-database-overview
--
Best regards,
Janice Losgar
Dartware, LLC
603)643-9600 x114
____________________________________________________________________
List archives:
http://www.mail-archive.com/intermapper-talk%40list.dartware.com/
To unsubscribe: send email to: [email protected]
