Get live statistics of your timesheet data using the module Report.

Various layouts and contents are available.

Here below is an example to show the hours done by customers:

Export your data

At the bottom right of the module, there is a link to export your data in a CSV format, the typical spreadsheet format.

Get more information about exporting your data.

Change an existing report

The report module is very flexible. You can start from the standard reports that are provided by default.

Here is how to change them to get exactly the information you need:

Click the bottom left button: Change this report, you should get the screen below:

Here are the options available for a report:

1. Chart type
   Here are the types of chart available
   
   
   
   Note: The charts use SVG which is available on most devices and computers.
   Android devices does not support SVG by default. As a result only the table format is available when you see a report.

2. Units
   
   

   

   
   

   Check the Billing and Costs section if you want to use it.

   
   

   billing ratio - %, gives you the percentage of billable hours against non-billable ones.

   profitability and profitability - % compare the billing amounts and the cost amounts
   
   

3. By...
   This is the first division of the results.
   It can be entities, time units or billable/unbillable hours as seen below:
   

   

   
   Time automatically will split the period you are looking(year, month, week,...) in the next smaller unit.
   eg: if you are looking the hours of a month, the time will be divided in weeks.
   

4. then split by... (for 2D charts: bars, column, table,...)
   This is the second possible division of the chart.
   A kind of third axis to see more data within a chart.
   This is not available in pie charts.
   
   
5. Reverse
   Click it to reverse the axis
   
   
6. Optional
   Each step you add will filter your report.
   eg: if you add a step, with subprojects. You will only have hours related to subprojects.
   
   However if you want to report on projects that have either subprojects or not, tick the Optional box for subprojects.
   The report will not filter on subprojects anymore.
   
   
7. Starting color
   The chart rotates on a number of contrasted colors.
   By default it starts with blue, but you can choose another one.

Add a step to drill down

Once a report is configured you can add a step that will happen when you click the chart and drill-down to get more details.

From the previous example with hours per customers.

We could see who worked for the customers.

Here's how to configure a drill down step.

At the bottom of the Change report, click Add a step to drill down

A second step should appear, like below:

You can configure the 2nd step the same way as the 1st step.

Here we choose the same options, except ...split them by: People

How to drill down?

We start from the example:

Click the colored square next to a company to see who worked for it.

And you should get the overview by people for this company only like:

Note the top right navigation box, circled in red.

It tells you which entity you are looking at and allows you go back to the chart you clicked.

Another option is to drill down on both axis.

Let's say you want to know who did those 63 hours on BeeBole for that week and when.

If you click the chart area, it will filter on both: company and time.

You should get the details of hours for this company and the week of Jan 3rd:

The details are shown by days.

Now we can say that the second step will show the sales these hours represented.

Click again Change this report and change the unit of step 2

The chart is updated automatically with the sales amounts.