Within the time evaluations, you'll be able to evaluate the recorded times extensively. Various filters, groupings, and summations are possible. From here, you can export the times, create timesheets, mark them as accounted for, or forward them to invoicing tools.

Overview of the evaluations

You will find the reports in the main menu under Time reports.

The overview page is divided into My reports and Shared reports. However, you will only be able to see the Shared Reports section if these exist.

Under My reports, you will find all reports you have created, while Shared reports will show you all reports that other users have shared with you.

You'll be able to create a new report by clicking the green Add button. To open an existing report, click on its name.

Within the overview, it is possible to search for evaluations or delete them.

Create, save & share a time report

Once you have created a new report, you'll be able to name it at the top and then save it..

Use the action button on the right to delete the report or share it with your team.

You do not need to save your report to export or create invoices.

☝️Hint: You'll be able to display saved evaluations as a widget on the dashboard.

Use filters

The filters for creating evaluations are divided into three areas/rows:

  1. Time filter

  2. Data filter

  3. List options

1. Time filter

This is where it is possible to select the time range that is used within the evaluation. awork distinguishes between relative and absolute options. If you select a specific month (e.g. August), the evaluation will always show the data for August.

Of course, you'll still be able to switch between months manually at the top of the report. However, if you select a relative time range, e.g. This month, the current month will always be shown.

2. Data filter

Using data filters has several options:

  • Filter by user

  • Filter by project

  • Filter by activity

  • Filter by tags

  • Filter by billing status

  • Filter by note of times

All filters can be used in combination. An 'AND' operation is always performed.

So, for example, filtering by "all accounted time entries and specific activity". All filters are applied only when the Refresh button is clicked.

Filter by user

Here you'll be able to select one or more users and filter by them. To show all users again, just click on All users in the upper right corner.

Filter by project

Here you have two options. You can filter by a single project or use more specific filters like customer, project type, and project status.

Filter by activity

Here you'll be able to select the different activity types. To show all activities again, just click on All activities in the upper right corner.

Filter by tags

You'll be able to filter by task tags, project tags and user tags. To show all tags again, just click on All tags in the upper right corner.

Filter by billing status

The billing status can be used to filter time entries by Billed, Billable, and Non-Billable.

Filter by note of times

Here you'll be able to enter the content of the note you wish to filter by. To disable the filter, you'll be able to simply delete the text from the field.

3. List options

There are also several options for the list options:

  • Select grouping

  • Select summation by field

  • Sort list by

  • Select displayed columns

  • Set rounding

All list options will not be applied until the Update button is clicked. All selected options also affect the print option / PDF export and Excel export after grouping.

Select grouping

Here you'll be able to specify how the data should be grouped in the report. The groups are then displayed as headers in the list.

Select summation by field

Here you'll be able to set summations for the list. For example, if you sum by tasks, the list will show one entry for each task. This can then be expanded to reveal the entries below it.

Sort list by

Decide by which field the list should be sorted in ascending or descending order. You'll be able to sort by fields you don't want to show in the list.

Select displayed columns

Select which columns will be displayed in the table. Only the columns that are available for selection here can be displayed. It is not possible to add more columns.

Set rounding

You''ll be able to define how the entries are rounded. There are two options:

  • Round up or down to the next full unit (15 min., 30 min. or hour). Then e.g. 1:17 becomes 1:15.

  • Round up: Then the next larger value is always used, e.g. 1:17 becomes 1:30. [GIF; ROUND TIMES]

Export data (.pdf & .xlsx)

The data of the evaluation can be exported in two ways: either as a timesheet in PDF format or as an Excel spreadsheet.

☝️Hint: You'll be able to store your logo under Settings > General so that it appears on the PDF.

To get an excerpt of the filtered values as a PDF and attach it to the invoice, e.g. in the invoice tool, click on the document icon. The print window of your browser will open. Now that you are ready, you'll be able to make various settings (depending on your browser) and print the statement or save it as a PDF. The groups, totals and column filters that you have selected will be taken into account.

☝️Note: If, for example, a link is visible at the bottom of the PDF, it is likely caused by your print settings. Here you need to disable this information in the print window.

Totals and charts in the summary

Within the summary, you will find the sum of all displayed times (purple), the billable value (yellow), the billed value (green), and the non-billable value (red).

There are three settings for the graph: Bar Chart, Matrix, and Pie Chart.

awork automatically displays the Bar Chart if the data is not grouped, and for grouped data, it automatically uses the Matrix view.

1. Bar chart

If the evaluation is not grouped, bars are displayed in the height of the recorded times for the respective time range. By moving the mouse over the entry, the exact date and value of the recorded hours will be displayed.

2. Matrix

If the evaluation is grouped, a matrix is displayed. The rows correspond to the respective group of the evaluation. The matrix itself contains the entries for the respective units, e.g., days, and at the end, the total sum for the group. By moving the mouse over the entry, the exact date and the value of the recorded hours is displayed.

☝️Note: For better readability, all values are rounded on an hourly basis. Moving the mouse over the entry will display the exact value.

3. Pie chart

If the evaluation is not grouped, the ratio of the non-billable, the not yet billed, and the already billed times are displayed here. If the evaluation is grouped, the ratio of the group totals is displayed. When the mouse is moved over an entry, the value of the entry and the percentage are displayed.

Edit times separately or several at the same time

There are several ways to edit times in the evaluation view.

Edit single times

Firstly, you'll be able to open the edit window by clicking on the action button of a time and can then edit the entry.

Secondly, you'll be able to edit non-aggregated times in the list directly by clicking on the corresponding fields. This is possible for the fields 'duration and date'.

Edit multiple times at the same time

You'll be able to edit multiple times at the same time, e.g. to mark them as billed or to move them to another project.

To do this, select individual times or entire groups using the checkboxes to the left of the list of times. An action menu appears at the bottom of the screen. Here you'll be able to perform various actions or cancel the selection.

Mark times as billed

You'll be able to mark all times in your report as accounted. To do this, build your desired filter and then click on the dollar icon in the upper right corner and select Set to accounted.

If you only want to mark some of the times as billed, then do that as described above about editing marked times at the same time.

☝️Hint: Only times that have not yet been marked as billed can be transferred to invoices.

Invoice times

The further billing of times is done by integrated invoice tools. Click on the dollar icon in the upper right corner and select Generate Invoice.

Find out more about billing times here.

Did this answer your question?