Summary by Group

Displays the total login counts and logins broken down by login type on a per group basis.

Description: Allows the user to determine the date range for all activity for the report.
Control Type: Multi-option

Use the following parameters to set start and end dates.

BCS Parameter: report_start_date (optional)
- Possible Values: <date_value in the format MM/DD/YYYY>
- Default Value: the first day of the preceding calendar month
BCS Parameter: report_end_date (optional)
- Possible Values: <date_value in the format MM/DD/YYYY>
- Default Value: 'now', or the last successful database refresh

Use the following parameters to set dates for a number of previous intervals, such as, "previous 3 months."

BCS Parameter: report_date_period (required)
- Possible Values: 1 (Days), 2 (Weeks), 3 (Months), 4 (Years)
- Default Value: 3
BCS Parameter: report_date_period_count (required)
- Possible Values: valid numeric value with the following maximum value for each report_date_period:
  Days - 9999
  
  Weeks - 999
  
  Months - 999
  
  Years - 99
- Default Value: 1
BCS Parameter: report_to_date (optional)
If you are using report_date periods, report_to_date=true will include all activity for the requested periods plus activity in the current period up to the current date and time. If report_to_date=false, the report will only include activity for the requested periods.
- Possible Values: true or false
- Default Value: true
Example:
- If report_to_date = true, the end date is always the date the report is run, up to and including the most recent database refresh.
- If report_to_date = false, the end date is the last day of the previous interval. For instance, if today is December 31, the ‘Previous [n] Months’ ends on November 30 and the ‘Previous [n] Years’ ends on December 31 of the prior year.
BCS Parameter: display_units (optional and used in chart templates only)
- Possible Values: 1 (Year), 2 (Quarter), 3 (Months), 4 (Weeks), 5 (Days)
- Default Value: 3

Description: Provides the ability to filter on one or two fields that exist in the report definition. You can define either an AND or an OR statement when using two filters. The field selector drop-down will include all fields that are available in the report definition.
Control Type: Logical filter
BCS Parameter: you cannot specify custom filters when running this report via BCS

Description: Allows the user to select one event and then filter that event by date.
Control Type: Single-select
BCS Parameter: date_filter_field
- Possible Values: Skillport_registration_dtm, last_login

Static Dates

To enter static dates, use the following parameters with a specific date for the filter_start_date and filter_end_date parameters:

BCS Parameter: filter_start_date (optional)
- Possible Values: <date_value in the format MM/DD/YYYY>
- Default Value: the first day of the preceding calendar month
BCS Parameter: filter_end_date (optional)
- Possible Values: <date_value in the format MM/DD/YYYY>
- Default Value: 'now', or the last successful database refresh
  Note: Default start and end dates will only be used if a date_filter_field value is entered and the date values are left blank. In this instance, the date values are dynamic and will update each time the report is run.

Dynamic Dates

For dynamic dates that change each time the report is run, use the following parameters:

BCS Parameter: filter_date_period (required)
- Possible Values: 1 (Days), 2 (Weeks), 3 (Months), 4 (Years)
- Default Value: 3
BCS Parameter: filter_date_period_count (required)
- Possible Values: valid numeric value with the following maximum value for each report_date_period:
  Days - 9999
  
  Weeks - 999
  
  Months - 999
  
  Years - 99
- Default Value: 1

Filter to Date

If you are using filter_date periods, filter_to_date=true will include all activity for the requested periods plus activity in the current period up to the current date and time. If filter_to_date=false, the report will only include activity for the requested periods.

BCS Parameter: filter_to_date (optional)
- Possible Values: true or false
- Default Value: true
Example:
- If filter_to_date = true, the end date is always the date the report is run, up to and including the most recent database refresh.
- If filter_to_date = false, the end date is the last day of the previous interval. For instance, if today is December 31, the ‘Previous [n] Months’ ends on November 30 and the ‘Previous [n] Years’ ends on December 31 of the prior year.

Description: Provides the ability to select included Login Types.
Control Type: Multi-select
BCS Parameter: login_type
- Possible Values: 1 (Skillport), 3 (Skillport - Mobile), 5 (BCS), 6 (OLSA)
- Default Value: All

Description: Provides the ability to roll up the activity of members of subgroups into higher-level group summary fields.
Control Type: Single-select check box
BCS Parameter: rollup_members_of_subgroups
- Possible Values: 0 (don’t roll up), 1 (roll up)
- Default Value: Don't roll up

Description: Provides the ability to include subgroups within the scope of the report.
Control Type: Single-select check box
BCS Parameter: select_subgroups
- Possible Values: 0 (don’t select), 1 (select)
- Default Value: Don't select

Description: Provides the ability to filter data based on user profile fields that have been configured and enabled on the User Profile page.
Control Type: Logical filter
BCS Parameter: N/A

Description: Provides the ability to specify user statuses.
Control Type: Multi-select
BCS Parameter: user_status
- Possible Values: 1 (activated), 2 (deactivated)
- Default Value: Activated

Description: Provides the ability to select one, many, or all users or groups as part of the filter criteria.
Control Type: Multi-select
BCS Parameter: user_list
- Possible Values: CSV list of <username> values
- Default Value: All
BCS Parameter: group_list
- Possible Values: CSV list of <group_orgcode> values
- Default Value: All
  Note: In some templates the Group or the User filter may not be available. For instance, if the report is group specific then the user filter may be disabled.