Link or bind data from DevMan directly onto MS-Excel to create an.
Use the many features of this popular analytical tool with built-in pivot tables to create reports and save them to be reused.
Reflect changed filters or latest information in Excel by a simple data refresh.
Reports can be regularly updated to see the latest statistics for all applications by simply refreshing the data in the spreadsheet.
This means there is no need to redraw or share the report each time you need an update.
|
•Save a copy of the report on your network / PC.
•When opening the report, you may be prompted to enable content and make it a trusted document – accept these prompts.
•Dashboard – this sheet reflects high level statistics of applications based on the source data.
•Source data – the other sheets list details for the applications. These sheets draw the information from DevMan and will show with alternating green and white rows.
•To refresh the report:
oGo into each source data spreadsheet, right click on the page and select ‘Refresh’. This will pull through any new data from DevMan.
oGo to the Dashboard sheet, select the Excel Data tab, then Refresh all to update the pivot tables and graphs.
oIf you get an error message referring to pivot tables overlapping, add in additional rows between pivot tables.
Source data spreadsheet refresh:
|
Dashboard spreadsheet refresh:
|
|
The steps to create an EIR are as follows:
•Create a saved search using the advanced reporter.
•Select Export or Statistics.
•Create a saved Export or Statistics selection, and then select Publish report.
•Save the published report, and then select Extract > To link.
•Copy the link. In an Excel spreadsheet on the Data tab, select the From Web button, and paste this as a Basic URL.
•Select your saved report, and then select Transform data. (For Excel help follow the link provided in the pop-up)
Detailed steps can be found in the Search and report printable quick guide.
|
