Changes and New Features

This page outlines multiple solution, dashboard, view, template and tool updates as well as new functionality available in Acendre Analytics.

Breaking - May 2022 updates:

April 2022 upgrade

These updates and functions are only available in the new Acendre Analytics for Recruit data. If you are only using Analytics Classic, speak to your Client Success Manager to move across.

Analytics Solution Updates

See https://acendreapac.atlassian.net/wiki/spaces/PER/pages/1198260252 for full range of services offered.

Calculated Filters

  • Calculated Filters allow you to quickly include/exclude certain results, like excluding test jobs, isolating or excluding your graduate programs, or eliminating any jobs archived more than a year ago.

Multi Select Extractions / Field Combinations

  • Multi Select Extractions and Field Combinations and other complex field manipulations/combinations that allow us to separate multiselect answers into different rows.

  • An similar solution is to combine multiple questions (eg Yes/No questions) into a single field to allow simple filtering and display of values, as used for Question Use and Question Options in the view SYS 4.8 Global Questions below.

Multi Select Extraction example:

 

Combination examples: Individual fields > combined field with values as separate rows:


System Dashboard and View Updates

Welcome Dashboard

  • Data refreshed to timestamp Brand new

  • Horizonal filters for Current Recruitment Brand new

  • New Changes/New Features page link

  • New to System Templates banner

 

System Templates Dashboard

  • Navigation Headers updates

  • Jobs Opening and Closing added to Current Recruitment

  • New Days At Step sub tab

  • New Global Questions sub tab with toggle to show/hide relevant reports and filters

    • Global Question Master and Table with drill throughs to Question Use, System/Form Templates, Answers, Contnt Loading and Report Options per GQ

    • Reportable GQ data with GQs per context, matching of context with question use settings, tracking of app data GQ volume, and mapping of GQs from Recruit to DWH to view folder and field

  • Updated Tools sub tab with new job/process templates and toggle to show/hide reports and filters

Global Questions toggle (default):

 

Reportable GQs toggle:

 

SYS 1.2 Job Process View

  • Expanded job template data to include jobs that aren’t templates that were copied to create other jobs.

    • Also available in SYS 1.1 Jobs and Apps

  • Process Workflow ID to link a Candidate Approval process to its related Assessment Process (same Workflow iD)

SYS 4.3 Form Configuration View

  • Added the Workflow ID, Copied from Process ID and (for Candidate Approval process templates) the associated Assessment Template ID.

SYS 4.8 Global Question Configuration View

  • Expanded question details; question use combined, total forms and by form type; question options combined and by individual setting; answer options; report options; and other GQ settings.

  • See the Global Question subtab and Global Question Configuration report details for more details.


New Custom/System Templates and Analytics Tools

See https://acendreapac.atlassian.net/wiki/spaces/PER/pages/982646819 and https://acendreapac.atlassian.net/wiki/spaces/PER/pages/1041432577 for full lists.

Custom EXEC Templates

Chart updates made to EXEC: Time to Fill (average by month instead of quarter) and EXEC: Essential Application Counts (pie charts for Gender/Diversity/Employee examples). brand new

Tools: Broadcasts

Dashboard broadcast data added to various broadcast reports. Brand new

*Note that dashboards can only be broadcast to analytics users and not email addresses or via advanced broadcast.

Tools: Global Question Form Template Comparison

Compare GQ use across the form templates for specific steps and processes, eg to see different in GQs used across different Interview steps. GQs are ordered by their minimum step order across forms.

BRand new

Current Jobs Opening and Closing

See the jobs that are opening and closing in a given period (default Today) and then a calendar view (default this calendar month). Adjust Summary and Calendar period as required.

Visible on the Current Recruitment subtab of the System Templates Dashboard.

Days At Step

View jobs by current workflow status (with drill through) and days at step by process and step type (via generic step name categorisation for job and assessment steps).

Visible on the Days At Step subtab of the System Templates Dashboard.

Global Question Configuration

Explore and filter your global questions, their various settings, and drill through to question use, linked system/form system templates, answers, content loading settings, and report options.

On the System Templates Dashboard, toggle to additional Reportable GQ data including use match (question use vs report context).

Visible on the Global Questions subtab of the System Templates Dashboard.E

Global Question Report Options

Explore Global Questions enabled for reporting in Acendre Analytics by context, whether that context matches the question use (ie the types of forms that GQ can be used on). No match means the GQ will always be null in that context.

Co-displayed with the new analytics tool Global Questions: Report Options Advanced report which maps GQs through to the relevant view(s), folder and field.

Tools: Job Templates

Tools: Process Templates

Explore your job and process templates, which ones are active, and how many active (not archived) jobs used those templates.

Drill through to active jobs using a template, and also see jobs linked to copies/other versions of that template (by name) or jobs copied from other jobs.

Visible on the Tools subtab of the System Templates Dashboard.

 

Tools: Form Configuration - Job Details System Form

Check the configuration of your Job Details form using this dedicated version of the Tools: Form Configuration report.

See your global questions, all of their parent-child relationships and dynamically related answers all in one table.

Report List

Lists Public reports by Folder and Sub Folder, filterable by a number of fileds and includes the Report ID for reference.

Visible on the Current Recruitment subtab of the System Templates Dashboard.

Global Questions: Report Options Advanced

View Global Questions enabled for reporting in Acendre Analytics by context, its table and field mapping in the DWH, and where they have been added in your custom view(s).

Visible on the Global Questions subtab of the System Templates Dashboard.


Analytics Functionality

Explore and expand selected items below for relevant detail. Note that these functions are now Available with some also marked as BRAND NEW or fixed.

Function

Area

Status

New Features

Detail

Function

Area

Status

New Features

Detail

Reports

Data

Available

  • Specify your calculated field result type, eg text or numeric.

Filters

Available

  • Specify if cached filter values are limited by other filters.

Charts

Available

  • Limit bar and column chart results.

Available

  • New Multi Pie Chart label options

  • New Logarithmic Scale option

Design

Available

  • Edit charts from the report canvas.

  • Add automatic text to the report canvas.

Dashboards

Available

  • Broadcast a dashboard as link or PDF.

  • View dashboards in full screen mode.

  • Bookmark and distribute filter values.

Available

  • Toggle between Chart/Table views

  • PDF Export subtab selection and notification

Content Configuration

Available

  • Set up dashboard tabs/subtabs in canvas mode.

  • Access additional widgets with canvas mode.

  • Add Quick Charts using the Blueprints widget.

  • Undo or redo your latest dashboard edit actions.

  • Add associated reports to a dashboard.

  • Show or hide the report name and menu.

  • Add a report to a dashboard multiple times.

  • Trigger events with dashboard widgets.

Filter Configuration

brand new

  • Horizontal Filter Widget allows you to place filters across the top of your dashboard.

Available

  • Left Hand Menu filter location.

  • Filter styling and auto run settings

Other Functions

Broadcasts

fixed

  • Bookmarks can now be used again for broadcast filter values after that defect was fixed.

Available

  • Monthly broadcasts are now more flexible.

Available

  • Includes filter tags in the Broadcast Subject

Drill Throughs

Available

  • Hard-coded filters available for drill throughs.

Exports

Available

  • XLS Column and Row Size

  • New PDF export options

Available

  • Icons from conditional formats

  • Section Summaries in XLS exports

Administration

brand new

  • Background Execution access (for Corp Writer permission only) to manage and delete current background tasks, eg long-running reports that are holding up other requests.

Broadcast Filters

Include filter values or full filter details in broadcast subjects. Available

Filter Parameter

Basic Example

Filter Parameter Text

Example within Broadcast Subject text

Filter Parameter

Basic Example

Filter Parameter Text

Example within Broadcast Subject text

Filter Value Only

Job Open

[filter:<filter title>]

eg [filter:Job Status]

Weekly jobs report for Finance where Job Status In List Job Open, Selection Process

eg Weekly jobs report for [filter:Group] where [filterDetail:Job Status]

Full Filter Details

Job Status equals Job Open

[filterDetail:<filter title>]

eg [filterDetail:Job Status]

Text Parameters

Include automatic text or values on a chart canvas. Available

Parameter

Parameter Text

Description

Parameter

Parameter Text

Description

Report Name

[reportname]

Adding this will place the name of your report in your chart. You can set the report name when you publish it.

Report Description

[reportdescription]

This will show your report's description. You can provide this description when you publish the report.

Cell Value

[tablevalue:column=<value>:row=<value>]

This parameter takes a column and row coordinate from a report table and displays its value in the text widget. 

For example, [tablevalue:column=1:row=1] will display whatever value is in the first column and row of a table.

Note:

  • If the target contains a drill link, the parameter will ignore it.

  • If the target contains special formatting, such as bold, typeface, and border, the parameter will ignore it and use the text widget formatting instead.

  • If the target column field format is set (eg, Sparkline Formatter, Image Link Formatter, Action Button etc.), the parameter will preserve that setting.

  • If the target table has hidden columns, these should be counted (eg, if column 1 has a hidden field before it, it is actually column 2).

  • If the target doesn't exist, the parameter will be replaced with an empty string.

Filter Value

[filter:<filter_order>]

This widget parameter returns the filter you have applied in your report. You can include any filter by entering its order number.

For example, [filter:2] displays the second filter. Note however, that if a specified filter yields no value, then (None)will be displayed by default.

Raw Filter Value

[filter:<filter_order>:format=<value>]

This operator is used to display the filter value in its raw form or with the applied format.

Use the following keywords in place of <value>:

  • Raw: This displays the filter value in its raw form, even if a format has been applied to it. (Applied by default.) For example: [filter:1:format=raw]

  • Formatted: Use this keyword to display the filter value with its applied format. For example: [filter:1:format=formatted]

Filter Value with empty text

[filter:<filter_order>:empty=<text>]

You can also specify the exact text to display, if the selected filter brings up no value, by using the Empty operator. Simply enter the text that you want to show in case the filter returns empty.

E.g. [filter:1:empty=No result] - If the first filter is empty, then the text 'No result' will appear where this text widget filter parameter is placed.

Note: The following characters should not be included in the text: “:”, “[” or “]”.

Column Aggregation

[total:<column_number>]

Use this to display the total aggregation value set on a column field, where the column is specified with its order number in the report.

For example: [total:3] will show the total aggregated value of the third column.

This value will depend on the aggregation type set on the total of the column field in the report, if any has been defined; otherwise it will display the total Sum value for metric fields, or the total Count for dimension fields.

Column Aggregation Type

[total:<column_number>:<aggregation_type>]

This is similar to the above parameter, however it displays the total column value depending on the aggregation type that you specify in here. This will override the existing aggregation type defined in the report. Use the following keywords to specify the aggregation type (ensure the same format is used for these keywords, i.e. all capital letters):

SUM, AVG, MAX, MIN, COUNT, and COUNTDISTINCT.

For example, [total:2:AVG] will display the total average of the second column.

Note: For dimension fields, only COUNT and COUNTDISTINCT can be applied.