Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 54 Next »

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

Breaking - April 2022 upgrade

  • Add horizontal filters to your dashboard

  • Use bookmarked filter values in your broadcast settings

  • ‘Data refreshed to’ timestamp on Welcome dashboard

  • Corp writer access to background tasks under Administration

  • New Tools: Global Question Form Template Comparison report to compare GQ use across specific process steps.

Full details to follow.

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 Analytics Solutions 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/Combination Preview

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

 Welcome Dashboard Preview

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

 System Templates Subtab and Header Preview
 System Templates Global Questions Preview

Global Questions toggle (default):

Reportable GQs toggle:

 System Templates Tools Preview

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)

 Job Process Field Preview

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.

 Form Configuration Preview

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.

 Global Question Configuration Preview

Question Use/Question Options as single and combined fields:


New System Templates and Analytics Tools

See System Templates and Tools and Analytics Tools for full lists.

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

 Tools: Global Question Form Template

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.

 Current Jobs Opening and Closing Preview

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.

 Days At Step Preview

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 Configuration Preview

Question Use pop-up:

System/Form Templates drill through, with additional drills to Form/Process configuration and associated active jobs:

Answer Details pop-up:

Content Loading pop-up:

Report Options pop-up:

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.

 Global Question Report Options Preview

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.

 Job Templates Preview

Job Templates by Active Jobs pop-up:

Job Copy data:

 Process Templates Preview

Process Templates by Active Jobs pop up:

Job Copy data:

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.

 Job Details System Form Configuration Preview

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.

 Report List Preview

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.

 Global Questions: Report Options Advanced Preview

Analytics Functionality

Key new analytics functions include:

  • control over whether cached filter values are limited by other report filters

  • limit bar and column charts to top (or bottom) N results

  • logarithmic scale for charts

  • auto text for chart canvases and broadcast subjects

  • a wide range of new dashboard config options

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

Reports

Data

AVAILABLE

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

 Calculated Field Result Type

Filters

AVAILABLE

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

 Cached Filter Value Options

New options allow you to determine whether other report filters are applied when caching filter values, and for limiting the complexity of the queries used to load cached filter values. See Filter Formatting > Value List Selection for the relevant filter.

Charts

AVAILABLE

  • Limit bar and column chart results.

 Trim Chart Dimensions

Trim bar and column chart categories to only show top or bottom # rather than all.

AVAILABLE

  • New Multi Pie Chart label options

 Multi Pie Chart Options

New multi pie chart display options include the ability to sort labels and configure font label formatting.

- Custom label formatting

- Label sort (under Series Settings > Color)

  • New Logarithmic Scale option

 Logarithmic Scale Option

A new logarithmic scale option for numeric axes, for all suitable chart types, allows better scaling from small to large numbers.

Design

AVAILABLE

  • Edit charts from the report canvas.

 Edit Charts from Canvas

Right click chart or the Transform icon in the chart’s top right corner to access this menu > Edit Chart.

  • Add automatic text to the report canvas.

 Automatic Canvas Text

Add report name, report description, specific cell values, filter values and column aggregations as automatic text. See table below for more detail.

Dashboards

Navigation and Distribution

AVAILABLE

  • Broadcast a dashboard as link or PDF.

 Broadcast Dashboard

Select the broadcast icon in the top right corner to set up a dashboard broadcast to selected users or email addresses.

  • View dashboards in full screen mode.

 Full Screen Mode

View a dashboard in full screen mode (within the Recruit frame).

To return to normal view, hit escape or click this icon (COMING SOON)

  • Bookmark and distribute filter values.

 Bookmark Filters and Distribute Bookmark

Bookmark filter values for repeated and/or default use.

Set as either:

1) Private to you, and if it is your default bookmark for this filter set

2) Visible to selected recipients, who they are (by user or analytics user group), and if it is their default bookmark.

AVAILABLE

  • Toggle between Chart/Table views

 Chart/Table Toggle

Switch from Canvas/Chart to table view on the dashboard and back again.

  • PDF Export subtab selection and notification

 PDF Export Options

Select which dashboard sub tabs to export via PDF, and navigate away from dashboard while the export runs in the background (with a foreground loading message).

Content Configuration

AVAILABLE

  • Set up dashboard tabs/subtabs in canvas mode.

 Dashboard Layouts

  • Access additional widgets with canvas mode.

 Canvas-Specific Widgets
  • Add Quick Charts using the Blueprints widget.

 Quick Chart Blueprints

Use a blue print widget to create a quick chart for your dashboard.

1. Select a blueprint.

2. Select Create Simple Report to create your report on the dashboard. (Select Create Advanced Report to go to the full report editor. Your report will be automatically added to your dashboard when published.)

3. Select your source view (usually Custom view 1.0), then any required dimension(s) and/or series.

4. Add any required report filters to the chart properties.

5. To access the advanced edit option for your simple report/quick chart, right click the chart > Advanced Edit.

  • Undo or redo your latest dashboard edit actions.

 Undo/Redo Dashboard Edits
  • Add associated reports to a dashboard.

 Associated Reports

Add the Associated Reports widget to a dashboard’s global content or subtab panels to provide links to additional reports.

  • Show or hide the report name and menu.

 Show/Hide Report Name and Menu

Show or hide the report name in the report properties panel.

Specify when the report menu will appear - inheriting the dashboard/subtab settings, always, on hover, or never. This gives access to report information, opening the report, or switching chart/table view.

  • Add a report to a dashboard multiple times.

 Report Branching

Report branching allows the same report - including the canvas, multiple charts or report table - to be added to the dashboard more than once without running the SQL multiple times.

  • Trigger events with dashboard widgets.

 Click Events

Go to selected report/widget settings > Action > Client Event to navigate to a specific sub tab, reset the dashboard or filters, jump to a report or go to an external link when clicking on that dashboard content.

Filter Configuration

BRAND NEW

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

 Horizontal Filter Widget

AVAILABLE

  • Left Hand Menu filter location.

 Filters in Left Hand Side Navigation

Enable Left Filters in the Dashboard Properties to add filters in the left hand menu.

  • Filter styling and auto run settings

 Filter Style and AutoRun

Access various filter display settings in the Filter Properties panel. Enable Auto run filters to refresh the dashboard as soon as a filter value is selected or entered.

Other Functions

Broadcasts

FIXED

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

 Use Bookmarks for Broadcast Filters

AVAILABLE

  • Monthly broadcasts are now more flexible.

 Monthly Broadcast Options

Specify if monthly broadcasts should go on a particular date of the month (eg 1st) or a specific day of a specific week (eg 1st Monday).

AVAILABLE

  • Includes filter tags in the Broadcast Subject

 Broadcast Subject with Filter Values

Add filter values or filter details to a broadcast subject using the [filter:<filter title>] or [filterDetail:<filter title>] tags. Full details in table below.

Drill Throughs

AVAILABLE

  • Hard-coded filters available for drill throughs.

 Hard-coded Filters

Hard-coded filters (ie cannot be changed via user prompt) can now be applied to child report filters in the drill through settings, in addition to field or (user prompt) filter values.

Exports

AVAILABLE

  • XLS Column and Row Size

 Format Column and Row Size

Automatically adjust the width and height of columns and rows based on their content.

  • New PDF export options

 PDF Export Options

New options on PDF export of dashboards and reports include page size, page orientation (AVAILABLE ), and saving settings as default for next time (COMING SOON ).

AVAILABLE

  • Icons from conditional formats

 Icon Exports

Icons used in conditional formatting can be exported as a scalable vector graphic to XLS and DOCX files.

  • Section Summaries in XLS exports

 Section Summaries

Section summaries are now included 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.

 Background Execution

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 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

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.

  • No labels