Difference between revisions of "Reports"

From eMMS Help
Jump to navigation Jump to search
imported>Dpltech
imported>Dpltech
Line 12: Line 12:
 
=== Custom Columns Reports ===
 
=== Custom Columns Reports ===
  
Custom Columns Reports target your reporting needs more precisely than that of the standard reports. These report present data about equipment aggregated over a time periods for a customized set columns.
+
Custom Columns Reports target your reporting needs more precisely than the standard reports. These report present data about equipment aggregated over time periods for a customized set columns.
  
 
:[[File:CustomColumnReports.png]]
 
:[[File:CustomColumnReports.png]]
Line 34: Line 34:
 
=== Scheduled Reports ===
 
=== Scheduled Reports ===
 
:[[File:ScheduledReports.png]]
 
:[[File:ScheduledReports.png]]
::;A. Enabled: A report will be scheduled only when this is checked.
+
::;A. Enabled: A report will be generated only when this is checked.
 
::;B. Suspend: A report can be suspended by the system if an error in the configuration is detected during generation. You may change the configuration and un-suspend.
 
::;B. Suspend: A report can be suspended by the system if an error in the configuration is detected during generation. You may change the configuration and un-suspend.
 
::;C. Config Schedule: See (B) Schedule of [[Reports#Custom Columns Reports|Custom Columns Reports]].
 
::;C. Config Schedule: See (B) Schedule of [[Reports#Custom Columns Reports|Custom Columns Reports]].
Line 40: Line 40:
  
 
=== Report History ===
 
=== Report History ===
:A user can select and view a report from the Report History tab.
+
:You can view pre generated custom columns reports from the Report History tab.
 
:[[File:ReportHistory.png]]
 
:[[File:ReportHistory.png]]
  
Line 46: Line 46:
 
=== Report Shortcuts ===
 
=== Report Shortcuts ===
 
:[[File:ReportShortcuts.png]]
 
:[[File:ReportShortcuts.png]]
:A user also can select and view a report from the Report Shortcuts page. A report shortcut can be created from the expandable menu of a report as below.
+
:Report shortcuts are reports with pre-selected filters that can be created from the expandable menu of a report.
 
::[[File:ReportShortcut.png]]
 
::[[File:ReportShortcut.png]]
  
Line 52: Line 52:
 
== Advanced Filtering ==
 
== Advanced Filtering ==
  
Advanced filtering allows you to apply search filters to your data so that you can view customized, detailed, quick reports for accessing the right information at the right time.
+
Advanced filtering allows you to apply search filters to your data so that you can view customized, detailed, reports.
  
  
Line 60: Line 60:
  
 
=== Equipment Selection ===
 
=== Equipment Selection ===
:You can choose to view only devices assigned to certain accounts, of particular equipment types and the devices last known equipment location.
+
:You can choose to view only equipment assigned to certain accounts, that are of particular types or that are in particular regions.
  
 
=== Data Selection ===
 
=== Data Selection ===
:The data selection filters allow you to select as many rows as you choose and apply data specific filters to that data set. Filters include; Data locations, reason type and to prioritize active equipment. You can then sort those rows further by any viewable column in either ascending or descending order.
+
:The data selection filters allows further filtering of rows if they don't meet certain criterion. Filters include; Data locations, reason type. You can sort rows by most viewable column in either ascending or descending order.
  
:If any of the filters are changed, the data will no longer reflect the current state of the filters. To indicate this situation, the Go button is shown in orange and must be clicked to re-query the report data with the currently selected filters.
+
:If filters are changed, data will no longer reflect the current state of the filters. The Go button will be shown in orange and must be clicked to re-query the report data with the currently selected filters.
  
 
=== Region Filter Option ===
 
=== Region Filter Option ===
:When Regions filter is set, you have three filtering options as below. The eMMS system filters by the last location of device is in selected regions by default, but you can choose the others if you want.
+
:When the Regions filter is set, you have three filtering options shown below. The default is to filter equipment by verifying that their last location are in the selected regions.
 
::[[File:RegionFilter.png]]
 
::[[File:RegionFilter.png]]
  
 
== Export Data ==
 
== Export Data ==
  
:By clicking the Export(as .csv) button from the expandable menu of a report, you can export the current pages data and download it into a .CSV file which is easily imported into a spreadsheet.  
+
:By clicking the Export(as .csv) button from the expandable menu of a report, you can export the current visible data and download it into a .CSV file which is easily imported into a spreadsheet.  
 
::[[File:ExportedCsv.png]]
 
::[[File:ExportedCsv.png]]
  

Revision as of 19:55, 8 June 2015

Reports

Using the reporting tools, you can easily view your data in printable and exportable reporting formats. There are two types of report: Standard Reports and Custom Columns Reports. Selecting the Reports button at the left brings you to the Standard Reports tab by default.


Standard Reports

There are a number of pre-defined standard reports to choose from that make viewing essential data quick and easy. Simply choose the report from the Standard Reports tab and click the View Report button.
StandardReports.png


Custom Columns Reports

Custom Columns Reports target your reporting needs more precisely than the standard reports. These report present data about equipment aggregated over time periods for a customized set columns.

CustomColumnReports.png
A. New
Creates New Custom Report.
NewCustomColumnReport.png
Give your report a descriptive name, a DataTag and select the appropriate options for your new report. Then click the Apply button. This saves your changes and enables the "Add Columns" button.
B. Schedule
You have the ability to schedule custom columns reports. This brings you to the Schedule Report page where you can setup the schedule and apply some further options to the report generation. Give the new Scheduled Report a name, and move through the available options. You can assign the report to be generated for a particular Account, apply a Region filter and also generate the report for a certain equipment type. The remaining options define when the report will be generated, as well as generation offsets, day masks and ranges. You can also have the report be emailed to you via the email export options.
ScheduleReport.png
C. Config
ConfigCustomColumnsReport.png
Selecting the New column button brings you to the Add Report Column page. Here is where you define column(s) that will be included in the report. Give your column a name and select its type, action, field, alignment and Data Tag. You have 4 choices for Type; Machine Info, Value, Location and Alarm. Based on the Type selection, the options for Action and Field will change.
AddNewColumn.png
D. View Report


Scheduled Reports

ScheduledReports.png
A. Enabled
A report will be generated only when this is checked.
B. Suspend
A report can be suspended by the system if an error in the configuration is detected during generation. You may change the configuration and un-suspend.
C. Config Schedule
See (B) Schedule of Custom Columns Reports.


Report History

You can view pre generated custom columns reports from the Report History tab.
ReportHistory.png


Report Shortcuts

ReportShortcuts.png
Report shortcuts are reports with pre-selected filters that can be created from the expandable menu of a report.
ReportShortcut.png


Advanced Filtering

Advanced filtering allows you to apply search filters to your data so that you can view customized, detailed, reports.


AdvancedFiltersOnEqReport.png
AdvancedFiltersOnTimelineReport.png

Equipment Selection

You can choose to view only equipment assigned to certain accounts, that are of particular types or that are in particular regions.

Data Selection

The data selection filters allows further filtering of rows if they don't meet certain criterion. Filters include; Data locations, reason type. You can sort rows by most viewable column in either ascending or descending order.
If filters are changed, data will no longer reflect the current state of the filters. The Go button will be shown in orange and must be clicked to re-query the report data with the currently selected filters.

Region Filter Option

When the Regions filter is set, you have three filtering options shown below. The default is to filter equipment by verifying that their last location are in the selected regions.
RegionFilter.png

Export Data

By clicking the Export(as .csv) button from the expandable menu of a report, you can export the current visible data and download it into a .CSV file which is easily imported into a spreadsheet.
ExportedCsv.png


There's also the option to perform the exact same operations, but to export to a PDF file.
ExportedPdf.png