Custom reports
What is a report in Everhour
You can visit various dashboards and summary pages that Everhour has with information about your team, and that helps a lot to keep tabs on work. Sometimes, however, you wish to combine 2 dashboards into one. Maybe you even need to have a slightly different kind of information at your disposal: change the order of data appearance, delete some of the columns and add another one, apply a filter or conditional formatting.
You can achieve this by creating a custom report. A custom report in Everhour is an array of columns, filters, groups and conditions that serve to show the time spent by your team. The main advantage of it is comprehensive customization: you can tailor the report to look like you want and show only that type of data that you need. You can give it an outstanding name and save to easily find later.
Report columns and layout
To create a report, go to Reports page and click on the green button on the right. It opens a report draft mode with 3 blocks.
On the right are all columns that you can add to your report structure. They show a different type of data, you can read a description on each column. This view, in turn, is divided into 3 blocks: attributes, metrics and custom fields.
Attributes stay for different values for which we show time, like a project name or a task title. Metrics show different types of time, e.g. for a certain period or total, remaining and overtime. Custom fields created in external tools show up as columns in the 3rd block.
To add a column to your report structure, click on it or drag it to the middle of the draft. This is possible to move columns up and down here, as well as show column attributes for some of them (with a gear icon). For example, if you add a task column, you can display its tags, id or project name when you wish to see it in a report.
Some of the columns are visible only to admins, while supervisors and members don’t see them. These are columns that show financial information: Billable and Non-billable time, Invoiced and Non-Invoiced time, billable amount, Cost, Profit.
There are 3 types of layout for each report. Plain is a simple array of columns and rows with data per line. With subgroups is used to make one or several columns as main and group other columns by it in the body. Timesheet is a classical tabular format where you have a column, a row, and a value.
Report filters
On the left side of the report draft, you can see different filters allowing to narrow down the data you want to see. The first filter is layout where you create a combination for your reports. Period, Projects and Members allow you to specify a certain date range for a report and show up the particular project and member time in a report.
The Meta filter shows different types of metadata from your external management tools. An example of Meta is a tag, a task status, the name of a project section, the value of a custom field.
For example, if you have 10 labels and want to show only those tasks, that have a particular label.
One more filter is called Formatting where you can create conditions to highlight your time, ex. if a user reported less than 7 hours a day.
Change and see updates in a report
To make a change to your report, open it and click on Actions > Edit on the right side of the report. It opens the layout filter.
To quickly access some of the filters and sort data in a certain way, there are such choices as Filter, Sort and Columns on the left side of the report.
If you wish to change time directly in a report, click on a time sell to open an edit modal. Members can edit only their time, supervisors could edit time of others for projects they have access too, admins can edit anybody’s time.
When you track new time or change something in your project, like renaming a task or adding a new label, we usually update this information automatically after some time and this is enough to refresh the report.
If that does not happen, you can do a manual resync of tasks in a project where a change was made. Open your Projects > select a project > Resync Tasks. This is possible to make a resync for many projects at once by selecting them all.
After that, go back to your report and refresh the page to see new information.
Share and download a report
There is a way to share the same report among your Everhour team members by clicking on the Sharing filter. This saves your team’s time from making the same type of report. A member and supervisor can see only time from projects they have access to, and they don’t see any financial information.
When you wish to save a report on your computer or send to somebody outside of your team, click on Download. We give an option to export a report in a form of CSV, XLSX or PDF.
What else you should know
- To show tasks with estimates but with no reported time, you should select the period as Everything.
- A report with the same structure and period can display different data for different user roles. Admins could see all data in reports and use all columns. Supervisors and members can only see time from a project where they have access.
- If a project with time was archived, team members could see its time in a report. If a project from an external system with time was deleted, only admins can see the time from it in a report. Projects, created in Everhour, are permanently deleted with its all time from all users.
- We don’t show budgets and their progress in a report (for now).
- We don’t filter a report to show only billable/non-billable time (for now).