Charts & steering

Below the figures, the BI Dashboard moves from trends over time and categories to individual productions. Charts provide orientation and reveal notable patterns; any business interpretation should also consider the period, data quality and project context.

Monthly trend

The Monthly trend chart uses only per-event BI entries because these have a specific date. It shows:

• visitors per month as bars,
• visitors in the corresponding previous-year month as a dashed line,
• revenue per month on a second scale.

Figures entered only as project totals do not appear in the monthly chart, but can still be included in the KPI totals. The sum of the monthly bars may therefore differ from the visitor or revenue tile.

For very long ranges, Artwork limits the chart to a maximum of 36 months to keep it readable.

Evaluation by category

Revenue by category and Visitors by category group productions by their main category or sector. If no main category has been set, Artwork uses the first assigned category; productions without a category appear under a neutral entry.

Click a segment or bar to filter the production table to that category. The active category appears above the table and can be removed there. This chart filter is temporary and does not modify any project.

Effort in relation to output

The scatter chart compares each eligible production using:

• horizontal axis: effort score,
• vertical axis: revenue when revenue data is available, otherwise visitors.

The coloured quadrants compare each production with the median across all productions in the current period:

Click a point to open its project. The chart only appears when enough productions have usable effort or output values.

How is the effort score calculated?

The score is a weighted proxy using work indicators already available in Artwork:

2 × contracts + 1 × bookings + 1.5 × open tasks + 0.5 × project documents + 0.1 × representative effort hours

Effort ranges recorded in a project are converted to representative hour values for this calculation. The score is not a time account or cost calculation. It provides a consistent comparison for internal steering.

Reading the production table

The table shows for each production:

• category,
• visitors and any estimate marker,
• revenue and occupancy,
• number of performances,
• contracts per performance,
• bookings per performance,
• tasks plus documents per production,
• effort score.

Click a column heading to sort ascending or descending. Metrics per performance show a dash if no performance is available as a denominator. Click the project name to open the production.

The occupancy bar offers quick visual guidance, colouring low, medium and high values differently. The displayed percentage and the quality of its ticket and capacity data remain decisive.

A sensible interpretation workflow

1. Resolve data gaps and estimates first.
2. Check the period and previous-year comparison.
3. Select a notable category in a chart.
4. Sort the table by revenue, occupancy or effort.
5. Open affected projects and review source data and circumstances.
6. Only then draw conclusions or prepare reports.