What are these reporting functions?

What are these reporting functions?

How to customize a Custom Report

Custom reports provide a large amount of information, and there are functions provided to help narrow down the report to just the data required. We highly recommend using the functions available to make the information more manageable. This article goes over the functions you can use to make them your own. Using the custom reports and the functions below you can create almost any report you may need or want. If you feel there is information required for which you cannot create a report, please let our Support Team know. They may have a creative solution to help you!

Very Simple Functions

Sort

The Sort function allows you to sort a column in ascending or descending order.

Paging

The Paging function allows you to choose whether all information appears on one page, or if it should break at a selected number of rows.

Export

The Export function is located at the top right of the data box (below the function box). You are able to export the report you create to Excel, CSV or PDF.


Easy Functions

Layout

The Layout function allows you to select which columns of data you would like to display (show). This also allows you to remove (hide) data not required on your report. There are Select All and Select Noneoptions available on the bottom right of the function box.

Filter

The Filter function allows you to filter a column by a Comparison value. You select which column to filter, what comparison and what value.


Intermediate Functions

Group

The Group function allows you to group similar data together. This is most helpful when there are only a few options available, and you want to look at all employees, but want them broken into “categories” based on one or more columns.

Aggregate

The Aggregate function allows you to calculate totals, averages and similar for the entire report, and can also be used in combination with the Group function to display totals, averages and similar for the specific groups.


Advanced Functions

Chart

The Chart function allows you to create charts with the data within a report. You are able to create one of the following charts; Pie, Bar, Line, Curved Line, Scatter Plot, Heatmap, or Gauge. Each chart will require different selections made by you. If you require additional assistance, please contact our Support Team.

Crosstab

The Crosstab function allows you to create a crosstab/pivot table to show summarized information with groupings listed in both rows and columns. You will need to select a Header Values Column (the crosstab will have one column for each unique value) and a Label Values Column (the crosstab will have one row for each unique value). You also select what will be going into the crosstab cells, (what the content will be in the Aggregate Values Column), and what the Aggregate Function will be. If you need additional assistance, please contact our Support Team.

Formula

There is a button at the top of the Formula function box that says Formula Help. Feel free to review the attached page for some assistance with Formulas. If you require additional assistance, please contact our Support Team.

Remember to select Add or Ok (bottom left of the function box) to save the functions you’ve used and want to apply.


    • Related Articles

    • How do custom reports work?

      Opening a custom report Select Reports on the side menu and choose the Custom Reports tab. Click on any custom report to view or edit. Exporting a custom report to Excel 1. Once you open your report, adjust your filters and press Submit. The filters ...

    • How do I create a Gross Earnings Report?

      1. Select Reports on the side menu, click on the Custom Reports tab, and then select Pay Runs (under Payroll Reports). 2. Filter your report to the specific date range or pay period you would like to view, then press Submit. 3. Select Layout and ...

    • How to download Client Sales Tax Rate Report

      A new Client Sales Tax Report has been added to the Payroll Custom Provider Reports. This report shows the sales tax rate. To view and download this report, follow the below steps: 1. Sign into your payroll account and click Reports

    • How to generate the Temporary 10% Wage Subsidy Report

      To view and generate the 10% Temporary Wage Subsidy Report, follow the below steps: 1. Select Reports from the side menu and click on Custom Reports. 2. Under Payroll Reports, select 2020 10% Temporary Wage Subsidy report. 3. 2020 10% Temporary Wage ...

    • How to download important Payroll reports

      How to download Payroll Register Reports 1. Navigate to Payroll, then click on the Reports tab. 2. Under the Standard Reports tab, you’ll find the payroll register report under the Payroll Reports section, click on Payroll Register. 3. Select the ...