View Single Post

  #1 (permalink)  
Old 06-23-2004
Anonymous Anonymous is offline
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
Newbie question - Mapping/displaying frequency of events

Hi, new to MP2K and to this forum. I would like to export data from an Excel spreadsheet that shows the number of service incidents for computer assets at multiple addresses - typically, I'm looking to count the number of service incidents at multiple addresses within a large institution, such as a University campus or campuses. It is possible that the same asset number is serviced multiple times within a given time period, and it is also likely that multiple assets at a given address will be serviced. Is there an easy way to show a stacked chart or graph of frequency superimposed on a map of said region? (Pushpins are kind of messy when dealing with hundreds or thousands of incidents.) Also, will I have to summarize the data in Excel (pivot, for instance) prior to doing the import/link, or will MP2K handle the counting for me? Thanks.
Reply With Quote