Grouping and filtering reports
The Freckle report filters and grouping options let you easily focus on specific types of entries, and aggregate time to see the totals for specific time periods, projects, project groups or people.
Report filters let you focus your report to show only specific types of entries.
- Billable entries only: great to find out how much productive time your team has logged
- Unbillable entries only: when you want to find out about your company's overhead
- Entries by leaders, coworkers & supervisors only: see what your internal team has logged
- Entries by contractors only: see how many hours external contractors and freelancers have logged
Selecting a filtering option will instantly re-run the report and update the page. For extra filtering power combine these filters—for example, you can opt to see only unbillable hours by contractors.
Aggregating and grouping entries
Your Freckle reports can be optionally grouped in up to two levels and use aggregations instead of individual entries. One of the most common uses for this are weekly timesheets, which show how much time in total has been logged by each of your team members.
Indeed, Freckle comes with a handy list of presets, to quickly show you weekly or monthly timesheets, as well as daily totals and quarterly project reports.
The above preset is for a weekly timesheet. The preset selects grouping by nothing, showing totals by weeks (Sunday to Saturday), aggregating over all projects (projects are not listed individually) and showing individual person's hours.
If you change a grouping or aggregation option, the report will instantly update. Let's say you want to break out the timesheet by showing individual projects. Just click on Project under Project total by….
When you're aggregating time periods, if you hover over the row that lists the time period (in above screenshot that's "July 29 — August 4, 2013 (week 31)") you'll see a little report button to run a report over just this exact time period. This is great when you want to dig deeper into the data, for example if you find a week where you'd expect more time being logged than there actually is.
Note: as soon as you choose to aggregate or subgroup entries, you can no longer edit entries as only aggregated information is shown.
Search in full text of entries
If you're looking for very specific entries you can use the search field to filter down to only matching entries. Aggregation headers and totals will reflect the newly filtered down list of entries. The search filters down results live as you type. This is super handy to get some quick totals! Tip: If you're logging bug tracker or issue numbers, it's easy to calculate the time taken to fix an issue this way: