Report Types
There are many entities in Celoxis like projects, tasks and time logs. Some entities are also created by you using custom apps like bugs, risks, and issues. Each entity has its own attributes as well as attributes aggregated from other entities contained in it. For example, the project entity has its own attributes like name, priority, manager as well as attributes approved hours, invoiced revenue, planned labor cost, actual labor cost, etc. that are calculated from other entities like tasks, time logs and expenses.
When you create a report on Celoxis you have to first pick an entity on which to report. You can choose from:
| Typ | What you get |
|---|---|
| Projekt | Project attributes including data aggregated at the project level from timesheets, expenses and tasks like hours, cost, revenue, profit, margin, etc. |
| Aufgabe | Task attributes including data aggregated at the task level from timesheets and expenses like hours, costs, revenue, etc. |
| Zeiteingabe | Time entry attributes like hours, submitter, cost, bill amount, etc. You can use these individual time entries to aggregate data the way you want. For example, using this report, you can understand how time was distributed across activities per client. |
| Ausgabe | Expense line item data like amount, expense code, etc. You can use these individual expense line items to analyze your non-labor spends in a flexible way. For example, you can understand how expenses are distributed by expense codes per client. |
| Datei | File information like check-outs, total size, path, etc. |
| Diskussion | Discussion information. E.g. you can create a report that lists all active discussions where you are participating. |
| Anwendungen (e.g. Bug) | App information or data aggregated for each workflow instance from timesheets like hours, costs, etc. |
| Status-Update der Aufgabe | Progress update attributes of your tasks. For example, you can report on all the updates made in this week. |
| Aufgabe | Task assignment information like task, resource, planned vs actual hours, etc. An assignment refers to the allocation of one resource to one task. |
| Benutzer | User attributes. Read More. |
| Dashboard | A dashboard report. Read More. |
| Aktivitätsprotokoll | Activities happening on different entities - who did what and when. Read More. |
| Zeit stufenweise | Time phased data of hours, cost, revenue, utilization, etc. Time phased data is the distribution of data in time. You can read more about it later in this chapter. |
Zeit stufenweise
Time phased reports show how a quantity is distributed over time. For example, when you run a project report, you can see the total estimated cost of the project but if you want to understand the planned spend per week or month, then you will need to run a time phased report. Many quantities have time phased nature. E.g. budget, effort, cost, and revenue.
You can view time phased data in a tabular format as shown below or in the form of charts. Currently, unlike other entities, charts are not drill-down capable.
| Verfügbare Stunden | The working hours of a resource depending on the work calendar timings and exceptions. |
| Tatsächliche Kapazität | 1 - (Tatsächlicher Aufwand ÷ Verfügbare Stunden) as a percentage |
| Tatsächlicher Aufwand | Approved hours in time logs |
| Tatsächliche Auslastung | Tatsächlicher Aufwand ÷ Verfügbare Stunden as a percentage |
| Geplante Kapazität | 1 - (Geplanter Aufwand ÷ Verfügbare Stunden) as a percentage |
| Geplanter Aufwand | The number of hours a resource is allocated on a task |
| Geplante Nutzung | Geplanter Aufwand ÷ Verfügbare Stunden as a percentage |
| Tatsächliche nicht abrechenbare Stunden | Approved non-billable hours from time logs |
| Effizienz | Resource efficiency is calculated as Geplanter Aufwand ÷ Tatsächlicher Aufwand as a percentage. A value of 100% means the resource is performing exactly as expected. Less than 100% means worse than expected while more than 100% means better than expected. |
| Freie Stunden | The number of unallocated time for a resource i.e. Verfügbare Stunden - Geplanter Aufwand. |
| Freie Stunden (Echtzeit) | Shows free hours assuming remaining hours for a task is distributed as per allocation from the present date. Remaining hours for a resource is Geplanter Aufwand - Tatsächlicher Aufwand |
| Abgerechnete Stunden | Hours from invoiced time logs. |
| Tatsächliche abrechenbare Stunden | Hours from approved time logs marked as billable |
| Tatsächliche Kosten | Total of labor, expense and fixed cost. |
| Tatsächliche Arbeitskosten | Sum of cost from time logs |
| Tatsächliche Marge | Tatsächlicher Gewinn ÷ Tatsächliche Einnahmen |
| Tatsächlicher Gewinn | Tatsächliche Einnahmen - Tatsächliche Kosten |
| Tatsächliche Einnahmen | Sum of bill amounts of approved time logs and expenses |
| Abgerechnete Erlöse | Sum of bill amounts of invoiced time logs and expenses |
| Geplante Kosten | Sum of planned labor cost, planned non-labor cost and fixed cost |
| Geplante Arbeitskosten | The estimated cost of a resource working on a task. Total amount is distributed uniformly over the task duration. |
| Geplante Marge | Geplanter Gewinn ÷ Geplanter Umsatz |
| Geplanter Gewinn | Geplanter Umsatz - Geplante Kosten |
| Geplanter Umsatz | Geplanter Aufwand × Resource Rechnungstarif. Available only when company's billing model is user-based not activity-based. |
| Umsatzpotenzial | Verfügbare Stunden × Rechnungstarif. Available only when company's billing model is user-based not activity-based. |
Hide Total Columns
This option will hide the total columns from time-phased reports to help you easily focus on specific data.
