Tables are a type of custom report you can create in the My Reports area of Invoxy.
To add a new report go to Insights > My Reports and click Add Report.
When creating a table report, you'll need to name the report and select the Table the data will be coming from.
The table options available are:
Invoice Detail - Report on totals and line details from invoices.
Pay Detail - Report on totals and line details from pay runs.
Placement - Report on placement info (note that this is for information recorded on the placement itself, not for total labour on a placement - that would be the Time table).
Time - Report on time entries or total effort recorded in the Timesheets.
Once you've selected the table you'll be using, the list of available columns you can add into your report will be listed at the bottom of the options pane.
The available columns are split into two types - Categories and Measures. Categories are fixed data points, like names and dates. Measures are numerical values that can be measured, like hours and costs.
Click on a column to add it into your report. When you add a column it will appear in the Selected Columns pane. Measures will then have the additional option to choose how you'd like the measure to be collated - as a Sum, Average, Minimum, Maximum, or Count of each instance.
Under the Filters tab you can click Add Filter to filter your report to limit the results to certain criteria - for example, you might want a report for a specific candidate over a certain date range.
You can set each filter to be based on:
Value - e.g. placement name, client, a single date, etc
For values, simply select the Field you wish to filter by. Then select the Value you want included in the report and click Add Value. You can add multiple Values to a single filter. Click Save Filter when you're done
Range - usually most applicable to dates and values, but can also be applied to get all placements or people from A-M, for example.
For ranges, select the Field you you wish to filter by, then select the From value and the To value and click Save Filter.
Dynamic - dynamic ranges allow you to set a non-fixed date range, so that the data in the report updates automatically to fit the parameters you specify. For example, a dynamic range could show the last X weeks, next Y months, or the current month.
For dynamic ranges, select the Field you wish to filter by and the Type of dynamic range you'd like. If you select Custom, you'll also need to set the parameters. The Custom options available allow you to set the Last or Next number of Days, Weeks, Months, or Year.
Once you've applied all of the columns and filters you need for your report, click the button to reload with your settings applied.
You're then able to select Save if you'd like to save the report to your My Reports dashboard, or you can download the report as a spreadsheet by selecting Download Report under the menu button