Versions Compared

Key

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

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

Table of Contents
minLevel1
maxLevel1
Note

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 Filtersallow 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.Image Removed

Multi Select Extractions / Field Combinations

Multi Select Extractions and Field Combinationsand 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.

  • Expand
    titleMulti Select Extraction/Combination Preview

    Multi Select Extraction example:

    Image Removed

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

    Image RemovedImage Removed

    System Dashboard and View Updates

    Welcome Dashboard

    • New Changes/New Features page link

    • New to System Templates banner

    Expand
    titleWelcome Dashboard Preview
    Image Removed

    System Templates Dashboard

  • Navigation Headers updates

  • Jobs Opening and Closing added to Current Recruitment

  • New
    Panel
    panelIconIdatlassian-check_mark
    panelIcon:check_mark:
    bgColor#E3FCEF

    Breaking - May 2022 updates:

    April 2022 upgrade

    Note

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

    Image Added

    Multi Select Extractions / Field Combinations

    • Multi Select Extractions and Field Combinationsand 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.

    Expand
    titleMulti Select Extraction/Combination Preview

    Multi Select Extraction example:

    Image Added

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

    Image AddedImage Added

    System Dashboard and View Updates

    Welcome Dashboard

    • Data refreshed to timestamp

      Status
      colourYellow
      titleBrand new

    • Horizonal filters for Current Recruitment

      Status
      colourYellow
      titleBrand new

    • New Changes/New Features page link

    • New to System Templates banner

    Expand
    titleWelcome Dashboard Preview
    Image AddedImage Added

    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

    Expand
    titleSystem Templates Subtab and Header Preview
    Expand
    titleSystem Templates Global Questions Preview

    Global Questions toggle (default):

    Reportable GQs toggle:

    Expand
    titleSystem 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)

    Expand
    titleJob 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.

    Expand
    titleForm 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 detailsmore details.

    Expand
    titleGlobal Question Configuration Preview

    Question Use/Question Options as single and combined fields:

    Image Added

    Image Added


    New Custom/System Templates and Analytics Tools

    See System Templates and Tools and Analytics Tools 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).

    Status
    colourYellow
    titlebrand new

    Expand
    titleCustom EXEC Template updates.
    Image Added

    Tools: Broadcasts

    Dashboard broadcast data added to various broadcast reports.

    Status
    colourYellow
    titleBrand new

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

    Expand
    title
    Global Question Configuration Preview

    Question Use/Question Options as single and combined fields:

    Image Removed

    Image Removed

    New System Templates a Analytics Tools

    See System Templates and Tools and Analytics Tools for full lists.
    Tools: Broadcast reports with Dashboard data
    Image Added

    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.

    Status
    colourYellow
    titleBRand new

    Expand
    titleTools: Global Question Form Template
    Image Added

    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.

    Expand
    titleCurrent 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.

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

    Expand
    titleGlobal 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.

    Expand
    titleGlobal 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.of the System Templates Dashboard.

    Expand
    titleJob Templates Preview
    Image Added

    Job Templates by Active Jobs pop-up:

    Image Added

    Job Copy data:

    Image Added

    Expand
    titleJob Process Templates Preview
    Image RemovedImage Added

    Job Process Templates by Active Jobs pop -up:

    Image Removed

    Job Copy data:

    Image Removed

    Expand
    titleProcess Templates Preview
    Image Removed

    Process Templates by Active Jobs pop up:

    Image Removed

    Job Copy data:

    Image Removed

    up:

    Image Added

    Job Copy data:

    Image Added

    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.

    Expand
    titleJob Details System Form Configuration Preview
    Image Added

    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.

    Expand
    titleReport 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.

    Expand
    titleGlobal Questions: Report Options Advanced Preview

    Analytics Functionality

    Tip

    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 most these functions are already now

    Status
    colourGreen
    titleAvailable
    with some also marked as
    Status
    colourGreenYellow
    titleAvailable
    whilst some are awaiting deployment and
    BRAND NEW
    or
    Status
    colourYellowRed
    titleComing soonfixed
    .

    Filter Configuration

    Function

    Area

    Status

    New Features

    Detail

    Reports

    Data

    Status
    colourGreen
    titleAvailable

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

    Expand
    titleCalculated Field Result Type

    Filters

    Status
    colourYellowGreen
    titleComing soonAvailable

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

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

    Status
    colourGreen
    titleAvailable

    • Limit bar and column chart results.

    Expand
    titleTrim Chart Dimensions

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

    Status
    colourYellowGreen
    titleComing soonAvailable

    • New Multi Pie Chart label options

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

    Expand
    titleLogarithmic Scale Option

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

    Design

    Status
    colourGreen
    titleAvailable

    • Edit charts from the report canvas.

    Expand
    titleEdit 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.

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

    Status
    colourGreen
    titleAvailable

    • Broadcast a dashboard as link or PDF.

    Expand
    titleBroadcast 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.

    Expand
    titleFull Screen Mode

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

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

    Status
    colourYellow
    titleCOming Soon
    )

    • Bookmark and distribute filter values.

    Expand
    titleBookmark 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.

    Status
    colourYellowGreen
    titleComing soonAvailable

    • Toggle between Chart/Table views

    Expand
    titleChart/Table Toggle

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

    • PDF Export subtab selection and notification

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

    Status
    colourGreen
    titleAvailable

    • Set up dashboard tabs/subtabs in canvas mode.

    Expand
    titleDashboard Layouts

    • Access additional widgets with canvas mode.

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

    Expand
    titleQuick 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.

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

    Expand
    titleAssociated 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.

    Expand
    titleShow/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.

    Expand
    titleReport 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.

    Expand
    titleClick 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.

    Image Removed

    report or go to an external link when clicking on that dashboard content.

    Image Added

    Filter Configuration

    Status
    colourYellow
    titlebrand new

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

    Expand
    titleHorizontal Filter Widget
    Image Added

    Status
    colourGreen
    titleAvailable

    • Left Hand Menu filter location.

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

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

    Status
    colourRed
    titlefixed

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

    Expand
    titleUse Bookmarks for Broadcast Filters
    Image Added

    Status
    colourGreen
    titleAvailable

    • Monthly broadcasts are now more flexible.

    Expand
    titleMonthly 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).

    Status
    colourYellowGreen
    titleCOMING SOONAvailable

    • Includes filter tags in the Broadcast Subject

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

    Status
    colourGreen
    titleAvailable

    • Hard-coded filters available for drill throughs.

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

    Status
    colourGreen
    titleAvailable

    • XLS Column and Row Size

    Expand
    titleFormat Column and Row Size

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

    • New PDF export options

    Expand
    titlePDF Export Options

    New options on PDF export of dashboards and reports include page size, page orientation (

    Status
    colourGreen
    titleAvailable
    ), and saving settings as default for next time (
    Status
    colourYellow
    titleComing Soon
    ).

    Status
    colourYellowGreen
    titleComing SoonAvailable

    • Icons from conditional formats

    Expand
    titleIcon Exports

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

    • Section Summaries in XLS exports

    Expand
    titleSection Summaries

    Section summaries are now included in XLS exports.

    Administration

    Status
    colourYellow
    titlebrand 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.

    Expand
    titleBackground Execution
    Image Added

    Broadcast Filters

    Include filter values or full filter details in broadcast subjects.

    Status
    colourYellowGreen
    titleComing SoonAvailable

    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.

    Status
    colourGreen
    titleAvailable

    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.