AgileApps Support Wiki Pre Release

Difference between revisions of "Reports"

From AgileApps Support Wiki
imported>Aeric
Β 
(43 intermediate revisions by 2 users not shown)
Line 2: Line 2:


Unlike Views, where data is restricted to a single object, Reports can present data from any [[Object]] or from multiple objects ([[Database Views]]). Β 
Unlike Views, where data is restricted to a single object, Reports can present data from any [[Object]] or from multiple objects ([[Database Views]]). Β 
{{Note| For the new AgileApps UI, see [[Reports for New AgileApps User Interface]].}}


==About Reports==
==About Reports==
Line 64: Line 66:
#Click the Reports tab to display the list of available reports
#Click the Reports tab to display the list of available reports
#A series of options are available for each report
#A series of options are available for each report
#:;Email:Send a report via email, as an HTML file attachment to selected Users or Contacts. Find additional details at: [[Email a Report]]
#:;Edit:Modify the report and Save it, or Save As a new report
#:;Edit:Modify the report and Save it, or Save As a new report
#:;Delete:Delete the report
#:;Delete:Delete the report
Line 79: Line 80:
:;Excel Print: Save the report as an Excel .xls file
:;Excel Print: Save the report as an Excel .xls file
:;HTML Print: Display the report in a browser window; it can then be printed or saved from the browser
:;HTML Print: Display the report in a browser window; it can then be printed or saved from the browser
:;Export: Save the report as a .csv file
:;Export: Save the report as a .csv file. Only summary or overview of the report is available but not the record details.


===Add or Edit a Report===
===Add or Edit a Report===
To add or edit a report:
#From any application, click the Reports tab and choose one of the following options:
#From any application, click the Reports tab and choose one of the following options:
#*Add a new report, click '''[New Report]''' Β 
#*Add a new report, click '''[New Report]''' Β 
Line 88: Line 88:
#::*See [[Database View]] for more advanced report category options
#::*See [[Database View]] for more advanced report category options
#*Navigate to an existing report and click the ''Edit'' link
#*Navigate to an existing report and click the ''Edit'' link
#Select the Report Options, as described below
#Specify the Report Settings, described below.
#Click '''[Preview]''' to see how the report will appear
#Click '''[Preview]''' to see how the report will appear
#Click '''[Run]''' to generate the report
#Click '''[Run]''' to generate the report
Line 95: Line 95:


Repeat the process to create new reports from existing reports, building on the established data.
Repeat the process to create new reports from existing reports, building on the established data.
{{Note|<br>The navigation in the new runtime user interface is simplified by removing the legacy return to list functionality. The user can now directly use the browser back button to navigate between pages.}}


===Report Options===
<span id="Report_Options"></span>
:* '''Fields'''<br>Click the [[Report Fields|Fields]] tab and select the fields to include in the report.


:* '''Order'''<br>Optionally, click the [[Order]] tab to select the order of the columns in a tabular report, and/or to define the sort order for records in the report
===Report Settings===
<blockquote>
====Fields====
:Click the [[Report Fields|Fields]] tab and select the fields to include in the report.


:* '''Filter'''<br>Optionally, click the [[Report Filter|Filter]] tab to filter the records used for the report
:In this tab, click '''New Formula''' to define a calculation for this report. Use the [[Formula Builder]] to create it, and take advantage of [[Formula Functions]].
::''Note:'' To create a formula that is part of the record, use a [[Formula Field]].


:* '''Color Code'''<br>Optionally, click the [[Color Code]] tab to create conditional color-coding of report rows
====Order====
:Optionally, click the [[Order]] tab to select the order of the columns in a tabular report, and/or to define the sort order for records in the report


:* '''Group'''<br>Optionally, click the [[Report Group|Group]] tab to group records into collections based on the values in selected fields. Use these options to create both ''tabular'' reports and ''matrix'' (cross tab or pivot table) reports.
====Filter====
:Optionally, click the [[Report Filter|Filter]] tab to filter the records used for the report


:* '''Compute'''<br>Optionally, click the [[Report Compute|Compute]] tab to add metrics to the report
:Click '''Show Quick Filter Layout Configuration''' to give the user the ability to select the data that appears in the report. Then define the user's options in the '''Quick Filter''' tab.


:* '''Chart'''<br>If Grouping options were selected, click the [[Charts|Chart]] tab to select charting options
====Quick Filter====
:This tab appears when '''Show Quick Filter Layout Configuration''' is selected in the Filter tab.
Β 
:When that option is chosen, a "Quick Filter" section is displayed at the top of the report. In this tab, you specify the number of columns that appear in that section, and the fields shown in each column. The user can then specify data in those fields to select the records that will appear in the report.
Β 
:For example, assume you want to summarizes sales by region. If you have 12 regions, you could make 12 separate reports. Or you could create a single report and include region as a quick filter. The user can then select each of the regions in turn, and see the summary data for that region, because only records that have a matching region are included.
Β 
====Color Code====
:Optionally, click the [[Color Code]] tab to create conditional color-coding of report rows
Β 
====Group====
:Optionally, click the [[Report Group|Group]] tab to group records into collections based on the values in selected fields. Use these options to create both ''tabular'' reports and ''matrix'' (cross tab or pivot table) reports.
Β 
====Compute====
:Use the Compute tab to summarize data for records included in the report. Record counts can always be produced, but other options like total, average, max, min, mean, median, and standard deviation can be calculated for numeric and currency fields.
{{Note| Summary compute feature is currently available in the legacy user interface only. }}
Β 
====Chart====
:If Grouping options were selected, click the [[Charts|Chart]] tab to select charting options
</blockquote>


===Move a Report===
===Move a Report===
Line 116: Line 141:
:'''For example''': If you have granted visibility rights to Everyone to view a certain report, you cannot move that report into a folder that restricts rights to a certain Team.
:'''For example''': If you have granted visibility rights to Everyone to view a certain report, you cannot move that report into a folder that restricts rights to a certain Team.


To move a report:
'''To move a report:'''
#From any application, click the Reports tab
#From any application, click the Reports tab
#Click the Edit link next to the report you want to edit
#Click the Edit link next to the report you want to edit
Line 132: Line 157:
:'''For example''': If you have given [[visibility]] rights to everyone to view a certain report, you cannot move that report into a folder that restricts rights to a certain team.
:'''For example''': If you have given [[visibility]] rights to everyone to view a certain report, you cannot move that report into a folder that restricts rights to a certain team.


To Delete a Report:
'''To delete a report:'''
#From any application, click the Reports tab
#From any application, click the Reports tab
#Click the Delete link next to the report you want to remove
#Click the Delete link next to the report you want to remove
#Click OK in the confirmation. The report is removed from the Reports page.
#Click OK in the confirmation. The report is removed from the Reports page.
===Email a Report===
Reports can be emailed to other team members or any other recipient.
Reports can be attached to email messages in any of these file formats:
:* HTML
:* CSV
:* PDF
{{permissions|Export Views and Reports|Email a Report}}
To Email a Report:
#From any application, click the Reports tab
#Click the ''Email'' link next to the report you want to send. If the report is not visible, make sure the folder containing that report is selected in the Folders drop-down list.
#In the Send Report By Email page, complete the information under Receiver Details
#;To:Enter the name of one or more email recipients, or click the Lookup button to select team members
#;Subject:The report title appears by default, and can be edited
#;Message:The text that will appear in the body of the email message
#In the Choose Reports to be delivered section, complete the following information:
#Reports:The selected report is included by default
#:Optionally, select additional reports to be attached to the email message
#;Print Format:HTML is the default format
#:Choose from: HTML, CSV or PDF
#Optionally, click the checkbox to Print in Landscape format
#Click the '''[Send]''' button to send the email message


==Report Schedules==
==Report Schedules==
Line 169: Line 169:


;Considerations:
;Considerations:
*The Schedule Title is used as the email subject
:* The Schedule Title is used as the email subject
*Scheduled reports are submitted for processing at the time you request. However, processing and delivery of the reports depend on the current system load, so response time may vary. Please schedule reports '''well in advance''' of your need.
:* Scheduled reports are submitted for processing at the time you request. However, processing and delivery of the reports depend on the current system load, so response time may vary. Please schedule reports '''well in advance''' of your need.
*Multiple reports can be selected for scheduling
:* Multiple reports can be selected for scheduling
*Reports can be sent to groups of [[Users]], [[Teams]] or users based on their [[Role]]
:* Reports can be sent to groups of [[Users]], [[Teams]] or users based on their [[Role]]
:*At least one [[Users]], [[Teams]] or [[Role]] must be selected
:* At least on recipient must be specified.


===Schedule One or More Reports===
===Working with Report Schedules===
#Click the '''Reports''' tab
#Click the '''Reports''' tab
#Click '''[Schedules]'''
#Click '''[Schedules]'''<br>A list of report schedules is displayed.
#:A list of report schedules is displayed
#Click an existing schedule or click '''[New Schedule]''' to create a new one.
#Click an existing schedule or click '''[New Schedule]''' to create a new one.
#Fill in the schedule settings:
#Fill in the schedule settings.
#Click '''[Save]'''.<br>The Reports page displays a confirmation message and details about the scheduled report(s).
#Click '''[Save]'''.<br>A confirmation message appears in the list of report schedules.
Β 
{{Warn|<br>When you click '''[Delete]''' to remove a report schedule, there is no confirmation dialog,<br>and no way to undo the action.}}


===Schedule Settings===
===Schedule Settings===
<blockquote>
<blockquote>
'''Schedule Information'''
'''Schedule Information'''
:*;Schedule Title:The name for this report schedule.
:;Schedule Title:The name for this report schedule.
:*;Select Reports to Run:Click the Lookup [[File:lookupicon.gif]] icon to select the reports to run
:;Select Reports to Run:Click the Lookup [[File:lookupicon.gif]] icon to select the reports to run
:*:Optionally, click the Remove [[File:deleteicon.gif]] button to delete a report from the schedule
::Click the remove [[File:deleteicon.gif]] X to take a report out of the schedule
:*;Print Format:Choose one of the following formats:
:;Print Format:Choose one of the following formats:
::*PDF (the default setting)
:::*PDF (the default setting)
::*HTML
:::*HTML
::*CSV file
:::*CSV file
::*HTML with link
:::*HTML with link
:::Styled like the HTML report, this print format includes clickable links to records in the platform. Β 
::::Styled like the HTML report, this print format includes clickable links to records in the platform. Β 
:*;Send Empty Reports: Β 
:;Send Empty Reports: Choose whether or not to send reports for which no data was found.
:*;Message Comment: Add a comment to include when recipients are sent an email notification.
:;Message Comment: Add a comment to include when recipients are sent an email notification.
Β 


'''Select Users'''
'''Select Users'''
:* Click the Lookup [[File:lookupicon.gif|link=]] icon to select the email addresses of the recipients
:* Click the Lookup [[File:lookupicon.gif|link=]] icon to select the email addresses of the recipients
:* Recipents can be groups of [[Users]], [[Teams]] or users based on their [[Role]]
:*Recipients can be groups of [[Users]], [[Teams]], or [[Roles]]
::*If a Team is selected, an ''Include Subteams'' checkbox option appears
::*If a Team is selected, an ''Include Subteams'' checkbox option appears
:::*Unchecked by default
:::*Unchecked by default
:::*When checked, includes Subteams (Child Teams)
:::*When checked, includes Subteams (Child Teams)
::Duplicate email addresses are automatically omitted
::* Duplicate email addresses are automatically omitted
::*At least one [[User]] must be selected, in addition to any Teams or Roles.


'''Copy All Reports To'''
'''Copy All Reports To'''
Line 211: Line 212:
:* Specify "blind copy" addresses, separated by commas
:* Specify "blind copy" addresses, separated by commas
:* Specify management recipients (1st level management or 1st & 2nd levels)
:* Specify management recipients (1st level management or 1st & 2nd levels)
{{Note|<br>For security reasons the Email address and BCC options are deprecated. On saving the configuration of existing reports, these Email address will no longer receive messages.}}


'''Schedule Reports'''
'''Schedule Reports'''
:*;Run Date: Enter a date or click the Calendar button to select a date on which to run the report(s)
:;Run Date:Enter a date or click the Calendar button to select a date on which to run the report(s)
:*;Recurrence:How often you want to run these reports; The default option is Does Not Recur
:;Recurrence:How often you want to run these reports; The default option is Does Not Recur
:*;Run Time:Select the hour and minutes when to start running the report(s)
:;Run Time:Select the hour and minutes when to start running the report(s)
:*;Stop Date:Select Until and select an ending date to run the reports at the designated time and recurrence interval, or accept the default No End Date to run the report(s) at the selected time and recurrence interval endlessly
:;Stop Date:Select Until and select an ending date to run the reports at the designated time and recurrence interval, or accept the default No End Date to run the report(s) at the selected time and recurrence interval endlessly
</blockquote>
</blockquote>
===Change or Delete a Report Schedule===
#Click the Reports tab
#Click '''[Scheduled Reports]'''
#Click on the schedule Title to open the Schedule Reports detail page
#Make your modifications.
#Click the '''[Save]''' button to save your changes
#Optionally, '''[Delete]''' to remove the scheduled report.<br>'''Warning:''' There is no confirmation dialog, and no way to undo this action.


==Views, Reports and Object Inheritance==
==Views, Reports and Object Inheritance==
Line 233: Line 228:
[[Category:Analytics]]
[[Category:Analytics]]
[[Category:Views and Reports| 2]]
[[Category:Views and Reports| 2]]
[[Category:Design]]
</noinclude>
</noinclude>

Latest revision as of 10:25, 27 July 2022

Reports function like Views to organize your data for display and analysis, and provide a visual representation of your data, customized to present Performance Indicators as a Dashboard view of your business.

Unlike Views, where data is restricted to a single object, Reports can present data from any Object or from multiple objects (Database Views).

Notepad.png

Note: For the new AgileApps UI, see Reports for New AgileApps User Interface.

About Reports

The platform's reporting engine provides a full set of options for users to dissect and refine into the format needed to make strategic business decisions or to monitor key performance indicators. Data can be filtered, ordered, color-coded, grouped (computed), and charted to create management reports that give you visual insights into your business.

Each application in the platform includes a group of standard reports. You can modify an existing report, or build new custom reports on an ad hoc basis. In addition, these presentation features are included:

  • Build a tabular or matrixed report and optionally group information by rows and columns
  • Provide basic computation functions with optional row/column count
  • Color coding
  • Chart data in a variety of graphic styles
  • Email reports to team members
  • Join and present data from multiple objects to form ad-hoc reports (Database Views)
  • Display reports on the Dashboard as a Widget (chart-based widgets are especially powerful)
  • Export the report to PDF or to CVS file
  • Build ad hoc fields that support complex data modeling and analysis with Computed Fields and Summary Computed Fields

Charts

A variety of chart formats are available:

  • Pie
  • Funnel
  • Line
  • Bar Chart
  • Meter Gauge

When you click on a chart segment, several options appear:

  • Filter - See how the chart appears for selected records.
  • Drill Down - Select a record field and use it to subdivide the chart segment.
  • Group - Collect records that share the same value for a selected field.
  • Reset - Go back to the original chart.

Learn more: Charts

Tabular Reports

Tabular reports display data in rows and columns, as a table, with optional Color Coding to highlight significant rows.

Table of Orders by Customer

Matrix Reports

Matrix reports are used to organize and summarize your data, and are exceptionally well-suited for chart and dashboard views.

Orders by Source (Internet, Store, or Catalog) and by Offer (Discount, Purchase Incentive, or None).

The Matrix Report has a familiar format that you may know as a cross tabulation report (cross tab) or a pivot table. The resulting data is organized into a two dimensional grid which summarizes data (by total $, row count, or %).

The Matrix Report shows only summary information, based on the selected Row and Column Groups.

To create a Matrix Report, add one or more Row Groups and one or more Column Groups.

Reports in PDF Format

A Single Record can be printed as a PDF file.

Learn more: Print a Record

Working with Reports

This section describes how to run, modify and create new reports.

About [Save] and [Save As]

Considerations:

  • The [Save] and [Save As] actions allow reports to be saved to these folders:
  • My Report
  • Unfiled Public Report
  • Folder(s) created by the User
  • Folder(s) the User can access, as determined by Folder Visibility settings
  • [Save] replaces the original report
  • [Save As] makes a copy of the report to the selected folder

About Report Folders

Reports in Folders can be designated as visible to specific teams, roles, or users. See Report Folders for more information.

If a User has the viewing rights to a specific report, but does not have rights to view all the data, the report will only present the data that the user has permission to access.

Run a Report

To run a report:

  1. Click the Reports tab to display the list of available reports
  2. A series of options are available for each report
    Edit
    Modify the report and Save it, or Save As a new report
    Delete
    Delete the report
    Report Name
    Run the Report
  3. Click the Report Name to run the report

Report Actions

When a report is viewed, a series of action buttons become available:

Run Again
Rerun the report
Customize
Edit report options
Save
Save the report
Save As
Save the current report with a new name
Excel Print
Save the report as an Excel .xls file
HTML Print
Display the report in a browser window; it can then be printed or saved from the browser
Export
Save the report as a .csv file. Only summary or overview of the report is available but not the record details.

Add or Edit a Report

  1. From any application, click the Reports tab and choose one of the following options:
    • Add a new report, click [New Report]
    In the Category tab, select the desired Report Category
    • Navigate to an existing report and click the Edit link
  2. Specify the Report Settings, described below.
  3. Click [Preview] to see how the report will appear
  4. Click [Run] to generate the report
  5. Click [Save]
  6. Select the Visibility option to specify who can view the report.

Repeat the process to create new reports from existing reports, building on the established data.

Notepad.png

Note:
The navigation in the new runtime user interface is simplified by removing the legacy return to list functionality. The user can now directly use the browser back button to navigate between pages.

Report Settings

Fields

Click the Fields tab and select the fields to include in the report.
In this tab, click New Formula to define a calculation for this report. Use the Formula Builder to create it, and take advantage of Formula Functions.
Note: To create a formula that is part of the record, use a Formula Field.

Order

Optionally, click the Order tab to select the order of the columns in a tabular report, and/or to define the sort order for records in the report

Filter

Optionally, click the Filter tab to filter the records used for the report
Click Show Quick Filter Layout Configuration to give the user the ability to select the data that appears in the report. Then define the user's options in the Quick Filter tab.

Quick Filter

This tab appears when Show Quick Filter Layout Configuration is selected in the Filter tab.
When that option is chosen, a "Quick Filter" section is displayed at the top of the report. In this tab, you specify the number of columns that appear in that section, and the fields shown in each column. The user can then specify data in those fields to select the records that will appear in the report.
For example, assume you want to summarizes sales by region. If you have 12 regions, you could make 12 separate reports. Or you could create a single report and include region as a quick filter. The user can then select each of the regions in turn, and see the summary data for that region, because only records that have a matching region are included.

Color Code

Optionally, click the Color Code tab to create conditional color-coding of report rows

Group

Optionally, click the Group tab to group records into collections based on the values in selected fields. Use these options to create both tabular reports and matrix (cross tab or pivot table) reports.

Compute

Use the Compute tab to summarize data for records included in the report. Record counts can always be produced, but other options like total, average, max, min, mean, median, and standard deviation can be calculated for numeric and currency fields.

Notepad.png

Note: Summary compute feature is currently available in the legacy user interface only.

Chart

If Grouping options were selected, click the Chart tab to select charting options

Move a Report

Moving reports involves not only modifying what data is included or excluded from the report, but may involve changing folder properties to include Visibility rights to those reports.

For example: If you have granted visibility rights to Everyone to view a certain report, you cannot move that report into a folder that restricts rights to a certain Team.

To move a report:

  1. From any application, click the Reports tab
  2. Click the Edit link next to the report you want to edit
  3. Optionally, change the type of information that is generated by this report by modifying the Fields, Filter, Group, Compute, or Chart options
  4. Finish:
    • Click [Save] to save the existing report
    • Click [Save As] to save the changes as a new report, with a new name
  5. Select a Folder
    • If you save an existing report in a new folder, that report is moved to the new folder
  6. Click [Save]

Delete a Report

Editing or moving reports involves not only modifying what data is included or excluded from the report, but may involve changing folder properties to include Visibility rights to those reports.

For example: If you have given visibility rights to everyone to view a certain report, you cannot move that report into a folder that restricts rights to a certain team.

To delete a report:

  1. From any application, click the Reports tab
  2. Click the Delete link next to the report you want to remove
  3. Click OK in the confirmation. The report is removed from the Reports page.

Report Schedules

Lock-tiny.gif

Users that have the Manage Global Views/Reports permission can schedule reports. 

If you have reports that you run on a regular basis you can have the platform do the work for you and automatically email the reports to specified users.

Considerations
  • The Schedule Title is used as the email subject
  • Scheduled reports are submitted for processing at the time you request. However, processing and delivery of the reports depend on the current system load, so response time may vary. Please schedule reports well in advance of your need.
  • Multiple reports can be selected for scheduling
  • Reports can be sent to groups of Users, Teams or users based on their Role
  • At least on recipient must be specified.

Working with Report Schedules

  1. Click the Reports tab
  2. Click [Schedules]
    A list of report schedules is displayed.
  3. Click an existing schedule or click [New Schedule] to create a new one.
  4. Fill in the schedule settings.
  5. Click [Save].
    A confirmation message appears in the list of report schedules.

Warn.png

Warning:
When you click [Delete] to remove a report schedule, there is no confirmation dialog,
and no way to undo the action.

Schedule Settings

Schedule Information

Schedule Title
The name for this report schedule.
Select Reports to Run
Click the Lookup Lookupicon.gif icon to select the reports to run
Click the remove Deleteicon.gif X to take a report out of the schedule
Print Format
Choose one of the following formats:
  • PDF (the default setting)
  • HTML
  • CSV file
  • HTML with link
Styled like the HTML report, this print format includes clickable links to records in the platform.
Send Empty Reports
Choose whether or not to send reports for which no data was found.
Message Comment
Add a comment to include when recipients are sent an email notification.

Select Users

  • Click the Lookup Lookupicon.gif icon to select the email addresses of the recipients
  • Recipients can be groups of Users, Teams, or Roles
  • If a Team is selected, an Include Subteams checkbox option appears
  • Unchecked by default
  • When checked, includes Subteams (Child Teams)
  • Duplicate email addresses are automatically omitted
  • At least one User must be selected, in addition to any Teams or Roles.

Copy All Reports To

  • Specify email addresses of additional recipients, separated by commas
  • Specify "blind copy" addresses, separated by commas
  • Specify management recipients (1st level management or 1st & 2nd levels)

Notepad.png

Note:
For security reasons the Email address and BCC options are deprecated. On saving the configuration of existing reports, these Email address will no longer receive messages.

Schedule Reports

Run Date
Enter a date or click the Calendar button to select a date on which to run the report(s)
Recurrence
How often you want to run these reports; The default option is Does Not Recur
Run Time
Select the hour and minutes when to start running the report(s)
Stop Date
Select Until and select an ending date to run the reports at the designated time and recurrence interval, or accept the default No End Date to run the report(s) at the selected time and recurrence interval endlessly

Views, Reports and Object Inheritance

When creating Views or Reports in objects that are part of an Object Inheritance model, it is important to consider the following:

A Report or View that has no Filters will return all records from the designated object, including records from all parent object(s) in the hierarchy (following the path up to the root level).

To restrict the View or Report to only the desired objects, include the Object Name field in the Selected Fields list, and create a Filter on Object Name field to select only the objects of interest.