By User Reports

By User Reports are grouping database results by the "Staff/Groups" configured in the Setup Wizard (Settings > Setup Wizard).

Please note, that only "Staff/Groups" with "Primary" role are displayed.

As users are only available on the invoice lines, only this "Invoice Line" row type is available in this reports

Possible row types:

Invoice: Collects data from the invoice table
Invoice Line: Collects data from the invoice lines table
Formula: Use existing report variables or row results to calculate a value
/wiki/spaces/SVA/pages/10420360: Use a predefined SQL query (see Settings > SQL Query). These SQL queries can only be defined/edited by admins (for security reasons)
Alias Normalisation Factor: (currently not in use)

A By User Report creates a report that shows how each user/staff member on Profitdiagnostix has performed in certain areas that you choose. For example, the amount of consultations or dentals they have done in the specified date range etc.

Start this report by going to the settings tab >> reports >> create report on the LHS.

Display Name e.g.: Emma’s By User Report

Type: By User Report

Click on Create.

Create your first row for the first item you want to see for the staff performance indicator. For example, let's choose Consultations. Click on add row.

Display name: Consultations

Type: Invoice Line (consultations are found on an invoice line)

Aggregate: Count (you want to count each consultation)

Column: * - no need to change this

Date: e.g. 12 months - period_roll0to12

Here you would add a filter which would be the consultations.

Filter: Menu 1 is Product. Menu 2 is Inc. Menu 3 is transactional_prim_consult

Click on Create when this is completed.

Add further rows to view staff performance e.g. Repeat Consultations.

e.g. Dentals

Once you've added all the rows you want to see in your report, add the report to the dashboard.

Do this by going to your desired dashboard, clicking on the pen tool, searching for your report name e.g. "Emma's By User Report" then clicking on the plus symbol to add it to your dashboard.

Click on Report Settings and change the output type to "Pivot Table". This will display the staffs names in the left column, and the fields will be displayed at the top of the table. Click save.

Here is what the report looks like on your dashboard: