Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Contents

Gain a Use the Report Center to gain a fresh insight into your website with a wide range of usage reports and dashboards. In the Report Center, you can easily create dynamic reports that feature charts and tables, either by making use of one of CardioLog's existing templates, or by building a report from scratch. You can schedule a report reports to run automatically at any interval you would like, and you can preset permission to set permissions for who can view and /or edit a certain each report or dashboard to ensure that the right people have access to the right data. It's also possible to export a report to various in several standard formats including SharePoint web parts and CSV, and to email a report to a new address or a predetermined distribution list.

 

reports to distribution lists or individual colleagues.

Contents

Table of Contents
minLevel3

Anchor
create

...

new
create

...

new
How to Create a Report

  1. In the Navigation pane, under Report Center, click a folder in the Reports tree, and then select New Report...  (You can first create a Reports folder by selecting New Folder...)

    Image Added
    Create a new report
     
     
  2. While in the New Report dialog, select the Blank Report option and click Next:

    Image Added
    Create a blank report
    Blank Report


  3. Anchor
    create-new step 3
    create-new step 3
    Enter the Name and Description fields, select the number of columns for the report, and then click Next.

    To display dates in the Name and Description fields field of generated reports, use may the following variables: $now$, $today$, $lastday$, $thisweek$, $lastweek$, $thismonth$, $lastmonth$, $thisquarter$, $lastquarter$, $thisyear$, $lastyear$

    Image Added
    New Report details
    Schedule the report: according to a predetermined time interval (Property Details


  4. Choose to either schedule the report by day, week or month ), then click OK.
    Report scheduling
    The ad-hoc report generation option
    The blank report is now from the drop-down menu, or you can generate your report manually by selecting This is an Ad-Hoc report. Then click Next

    Image Added
    Report scheduling


  5. Your should now be viewing your newly created report in edit mode. The report also appears in the Navigation Pane and can be viewed and edited freely by anyone with sufficient permissions. 
  6. As you move your mouse cursor around the main window, you'll notice that each square of the report grid displays a plus sign (+), Click any square to add a new widget to in the main window of the report. Alternatively, you may click ADD in the top toolbar. Continue on to report editing for more information.


Anchor
edit report
edit report
How to Edit a Report 

Reports may be edited at any time without affecting previously collected data. 

  1. Find the report you would like to edit in the Navigation Pane, click it, and then select Edit from the contextual menu.

    Image Added
    Report Contextual Menu

  2. The report will now open in Edit Mode. When a report is in Edit Mode, you can add widgets Widgets to it.Click Add in the Top , change the time range, edit filters and export a CSV file for use with Excel and other spreadsheet applications.
  3. You can click any blank area of the report where a plus sign appears as you hover your cursor, or click Add at the top of the Central Area Toolbar and select a widget to add to the report (for a complete list of available widgets, see the Reports Gallery).
    Add widgets to a report
    . Continue on to widget editing for more information. The Reports Gallery contains a full description of all widgets.

    Image Added
    Blank Report Edit Toolbar


  4. Anchor
    top toolbar
    top toolbar
    The following actions are available in the Top Toolbar while in Edit Mode or Static Mode:

    • Add - add widgets to the report.
    • Actions Menu
      • Remove All Widgets - Clears all widgets from the current report.
      • Refresh - refresh the report's settings.
      • Generate Report - create the report in real time.

      Image Added
      Actions menu

    Upon analyzing the report, it is possible to
      • .

      Image Added
      Share menu

      The Filters menu allows you to limit the data displayed to specific pages, users or groups, or visitor segments for all widgets simultaneously.  Alternatively, you may edit each widget's filter preferences individually to suit your needs.
      Image Added
      Filters menu

  5. After designing the report, you can create a static version with real time data (by selecting Generate Report), or to wait until the report is automatically generated according to the report schedulingat the next scheduled interval. As long as there are no static versions for the report, it will be displayed in Edit Mode (if there are edit permissions for the current user) if it is selected from the Reports treewhen selected from the Navigation Pane, assuming the current user has sufficient permissions. Otherwise, the latest static version will be displayed.

    Image Added
    A Static Report
    The following actions are available in the Top Toolbar when the most recent report version  is displayed (static mode):
  6. Edit - change the report mode to Edit Mode in order for editing. 
  7. Refresh refresh the report settings. 
  8. Export to PDF - export the report data to PDF for printing (see How to Export a Report to PDF). 
  9. Export to CSV - export the report data to CSV file format (see How to Export a Report to Excel). 
  10. Send To - send an Email with a link to the report  (see How to Send a Report via Email). 
  11. Distribution List - send the report to a distribution list (see How to Set an Email Distribution List for a Scheduled Report). 
  12. Create Web Part - create a web part for the report (see How to export a report to a Microsoft SharePoint Web Part). 
  13. Regenerate Report - refresh the report data.
    Static report - right click menu
    with Active Widgets


  14. Edit the time frame for a static report by clicking the Date Range link the current Time Range menu on the top right of the report.  Select the desired date range and time interval and clickOK.
    Re-creation of the report with a newly selected date range
    , or customize to highlight a specific period of time.

    Image Added
    Choose Date Range Menu


    Image Added
    Customized Date Range

  15. To remove the report, including all previous versions right click the report and select Remove from title in the Navigation Pane and select Delete. To remove only the previous versions of the report and associated data, select Remove Delete Historical Data.
    The  The report's Historical Data refers to all prior report versions which are saved in the systemthat have been saved. If a version exists for a selected date range, the actual original saved version is displayed, and no query is submitted to the database. This is in order to save system resources and shorten the waiting time for the report.
  16. To modify the report properties (report title, description, number of columns and scheduling type), click the report and select Properties on the Navigation Pane.
  17. To view the report in a new window (without the CardioLog scheme) on the Navigation pane, click the report and select Browse

 

...

  1. streamline report generation.
  2. Select Properties in report's contextual menu in the Navigation Pane to modify the report information. There are six property fields and the first three listed here may be edited at any time:
    • Name: The name of the report as it appears in the Navigation Pane and all further saved versions.
    • Description: An optional description of what the report contains, or notes.
    • Scheduling: You may change between scheduled or Ad-Hoc report generation at any time. If a new report schedule is chosen, the report will be refreshed at the next relevant scheduled interval, not immediately. 
    • Created By: The username of the person who originally created the report
    • Create Date: The date and time the report was originally created
    • Last Access Date: The most recent time and date that the report was opened or viewed in CardioLog.

      Image Added
      Report Properties

  3. Select Permissions to edit who may view, edit or modify the report as described below
  4. Select Browse in the report's contextual menu in the Navigation Pane to view the report isolated in a new window, without the CardioLog scheme. Browse is only available after at least one report has been generated.

Anchor
edit widgets
edit widgets
How to Edit Report Widgets

Once a report exists in your CardioLog Report Center, you may continue to edit it whenever you see fit without affecting data collection or previous report data. The latest version of CardioLog allows you to easily drag and drop widgets within a report. expand and shrink charts, tables and maps, and simply click to add new widgets exactly where you would like them in a report. Visualizing your data is dynamic and intuitive. 

  1. To add a new widget, click any blank area of the report where a plus sign appears as you hover your cursor over the central area, or click Add at the top of the Central Area Toolbar and select a widget category.

    Image Added
    Add Widget Dialogue

  2. Click the category type you'd like and you'll be presented with a list of all available widgets in the category. Click on the icon of the available widget type you'd like: map, chart, meter or table. The new widget will now appear in your report. To add more widgets, repeat these two steps.

    Image Added
    Page Views Widget Category

  3. Once a widget is available in your report, you can edit all filters and time ranges for each widget separetely from the whole report as long as the report is in Edit mode.
  4. Click on the title of a widget to move the whole widget to any part of the report's display, and to rearrange the presentation of the report.
  5. You can click on the right-side or bottom border of any chart, table or map widget to resize it to a comfortable view. This is especially helpful for charts and tables depending on the type and amount of information presented.
  6. In addition to full report export options described further below, you can also export individual widget data to a CSV file. Simply click on the setting gear in the upper right corner of any widget and select Export to CSV. A CSV will be downloaded to your browser's default download location.

Anchor
tips efficient
tips efficient
Tips for Efficient Report Creation

The amount of resources needed for report processing depends on the number of scheduled reports, the number of database queries for each report and the timeframe selected for the reports (reports for 365 days require more resources then reports for 30 days). To ensure optimal operation, make sure you follow these recommendations: 

  1. Number of Queries (Widgets) per Report - Limit the number of widgets in a report to a maximum of 6.
  2. Number of Results (Rows) per Query - Display only the top 100 rows in tables.
  3. Report Filters - Define a black list rule when possible and avoid using the exclude (!) condition in the report filters.
  4. Report Scheduling Type - Make sure that the report scheduling type (daily/weekly/monthly) is in correspondence to the report date range, for example:
    When a report's date range is "Last Month", schedule it to run once a month.
    When a report's date range is "Last 30 Days",schedule it to run once a day.
  5. Report Type ("By URL" Widgets) - Avoid using the "By URL" widgets (for example - "Events" (Page Views by URL) unless needed. When creating a report for a web site, search the website in Object Explorer (Analysis Center), and use the appropriate tree item as the source of your report.
    Use the "By URL" reports only for: 
    • Web sites which do not exist in Object Explorer
    • Retrieving URL Parameters in the report
    • Tracking banner and button clicks
    • Tracking custom events
  6. Number of Scheduled Reports - Delete unused scheduled reports. Use the CardioLog Analysis Center for real time queries or to create an Ad-Hoc report and generate it manually on demand.


Anchor
copy
copy
How to Copy a Report

 This useful feature allows you to copy an existing report and attach a Website Item from the Object Explorer.

  1. On the Navigation pane, under Report Center, click a report from the Reports tree and select Copy.

    Image Added
    Copy report dialogue

  2. In order to include a Website Item, select the ellipses on the right to open the Object Explorer

    Image Added
    Object Explorer

  3. To change the location where the report copy will be saved, click the ellipses to the right of the Folder text box.
  4. Click OK to save your copy.
  5. The copied report will now appear in the Navigation Pane, in the folder you have chosen.


Anchor
create-template
create-template
How to Create a Report

...

Based On A Template

  1. In the Navigation Pane under Report Center, click a folder in the Reports tree and select New Report from the contextual menu.
  2. In the New Report dialog, select the New Report From Template option and click Next.
  3. Select the Report Template you would like to use in the Report tree.
  4. Continue with the new report creation steps as described above in How to Create a New Report. For more information see "Report Templates."

    Image Added
    New Report Template browser


Anchor
permissions
permissions
How to Set Permissions for a

...

Report 

Permissions are available in CardioLog installations which include integration with Active Directory.

You can set view, edit (Edit Mode), modify (properties and permissions) and remove (delete) for a specific report for any user or group in Active Directory. By default, the report creator has full control permissions, while view permissions are given to everyone. Additionally, Users and groups can be added, and deleted. Members who have been granted access can also modify existing permissions.

  1. In the Navigation pane, under Report Center, click a report from the Reports tree and select Permissions.
  2. In the Permissions dialog, select the desired permissions for the listed users by activating or deactivating the check boxes. User permissions precede group permissions. To assign permissions for all users, use the default "All" group

    Image Added
    Permissions window

  3. To add a user or group, select Add and search for the desired user or group. Click OK to confirm your choice

    Image Added
    Users and Groups search window

  4. To remove user(s) or group(s), select the check box on the left next to the user or group you would like to no longer access the report and then click Remove.
  5. Click Save to save the permissions.


Anchor
export excel
export excel
How to Export a Report to Excel and Other Spreadsheet Applications

You can export a report to CSV file format, which can then be read by most spreadsheet applications. Unlike other file types, you may export a report that is actively being edited, or has not been generated yet.

  1. Click Export to CSV from the Share menu.

    Image Added
    Share menu in Edit mode

  2. The report will be downloaded to your default downloads location.


Anchor
export

...

pdf
export

...

pdf
How to Export a Report to PDF

...

You can export a report from the Report Center to PDF format. The report must be in View Mode. Click Generate Report from the Actions menu if a Static Report does not exist yet.

  1. When the report is in View Mode, you will have 3 options to Export to PDF from the Share menu.

    Image Added
    Share menu in View mode

    • Export to PDF (A4) - the report will be saved as a PDF file with page size A4.
    • Export to PDF (Letter) - the report will be saved as a PDF file with page size Letter.
    • Export to PDF (As is) - the report will be saved as a PDF file with a custom page size (report dashboard size).

  2. When selecting Export to PDF (A4) or Export to PDF (Letter), you will be able to select the page orientation - Portrait or Landscape.

    Image Added

  3. The report will be downloaded to your default downloads location.

You can also control the report layout by printing the report and saving it as PDF:

  1. On the Navigation pane, under Report Center, click the report from the Reports tree and select Browse. If the Browse option is grayed out, select Open and click Generate Report from the Actions menu, to generate a static report.
  2. In the new report window, open the browser settings menu and select Print.
  3. In the Print Preview window, open the advanced settings and edit the scale options in order to shrink the report layout to fit the page.
  4. Choose Save as PDF in the printer destination.

    Image Added
    Example - Print settings in Chrome

Anchor
send email
send email
How to Send a Report via Email

You can send an email with a unique link to the report, with the data in the report automatically refreshed. Alternatively you can send an email with current data as a PDF or CSV file. The report must be in View Mode. Click Generate Report from the Actions menu if a Static Report does not exist yet.
  1. When the report is in View Mode, click Send To from the Share menu.
  2. In the new email window, enter an email address
  3. Choose how you would like your recipient to view the report and click OK.

    Image Added
    Send Email window

Anchor
email

...

distribution
email

...

distribution
How to Set an Email Distribution List for a Scheduled Report

Once a new non ad-hoc report is created, an automated email can be sent to a predefined distribution list. This email includes a unique link, a PDF file or CSV file attachment with the most recent report data. The email may be sent to the distribution list monthly, weekly or daily, according to the report's scheduling preference.

  1. Open a report in View Mode and select Distribution List from the SHARE menu.
  2. Enter an email address in the text box and click the Add button to add the address to the distribution list.
  3. Add any additional email addresses you would like to include. 
  4. Click Save.

Image Added

Distribution List Dialogue

 

Anchor
export sharepoint
export sharepoint
How to Export a Report as a Microsoft SharePoint Web Part

A web part is a component which displays data in a Microsoft SharePoint Portal. You can create a web part that displays a report from Report Center and add it to any page in the portal. The web part will automatically maintain the report's most recent data according to the report's scheduling preferences.
  1. Confirm the report is in View Mode.
  2. Click Generate Report from the Actions menu if at least one Static Report does not exist yet. Click Create Web Part from the Share menu.
  3. In the Create Web Part window, choose if you would like to embed the web part in a SharePoint classic page or a SharePoint modern page.

    Image Added
    Create Web Part Dialogue

  4. When selecting Create web part for SharePoint classic pages and clicking OK, the report will be downloaded as a DWP file to your browser's default downloads location. You can then add the dynamic Dashboard Web Part to your SharePoint classic web site.

    Image Added

    CardioLog report web part displayed on a classic SharePoint site

  5. When selecting Create web part for SharePoint modern pages and clicking OK, the web part code will be copied to clipboard. You can then embed the web part code in your SharePoint modern pages using the Embed option. Please note that only secure content can be embedded; therefore the CardioLog web application must be configured with SSL (see instructions under How can I configure secure access to the CardioLog website with HTTPS? in this guide for more details).

    Image Added
    CardioLog report web part displayed on a modern SharePoint site

Anchor
view-sharepoint
view-sharepoint
How to View a Report from SharePoint's Site Actions Menu

To view usage reports from within your SharePoint portal, via the "Site Actions" menu, install our CardioLog Usage Reports SharePoint FeatureThe site action feature can be deployed on the entire farm or for specific web applications. 
The CardioLog Usage Reports SharePoint Feature allows you to access CardioLog report templates directly from your SharePoint portal.
  1. The CardioLog system administrator must first create and publish report templates. These templates will then be available from all SharePoint portal pages.
  2. Once logged into the SharePoint portal, click the Site Actions settings gear to access the page options, By default, the logged in user requires SharePoint view permissions to see the report.
  3. Click Site Statistics to generate a usage report for your page. The report will open in a new browser tab or window depending on your local preferences.
  4. Select the desired report template and date range in order to run a relevant usage report for the page you are visiting.

Image Added
CardioLog Site Statistics SharePoint Menu Item