Charts & steering
Explore trends, categories and effort/output comparisons down to each production
The BI Dashboard moves from trends over time and categories to individual productions. The Overview view contains the monthly trend and the category charts, the Steering view the effort-vs.-output chart and the production table. 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 month of the comparison period (by default the previous year) 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 whole dashboard — tiles, charts and the production table — to that category. The active category is displayed and can be removed there. This filter is temporary and does not modify any project.
Effort in relation to output
The scatter chart in the Steering view 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:
| Colour | Classification |
|---|---|
| Red | high effort, low output |
| Green | low effort, high output |
| Indigo | high effort, high output |
| Grey | low effort, low output |
Click a point to open its project. The chart appears once at least three productions in the period have figures.
A comparison, not an automatic judgement
“High” and “low” refer only to the median among the productions currently being compared. Artistic quality, strategic importance, public remit and special production circumstances are not assessed automatically.
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: 0–10 counts as 5, 10–25 as 17.5, 25–50
as 37.5, 50–100 as 75 and 100+ as 125 hours. The info tooltip on the
column heading Effort score states the formula. 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 (only with an active Sage interface),
- tasks plus documents per production,
- effort score,
- once plan values exist: plan visitors, plan revenue, plan costs, costs attainment and attainment.
The table is initially sorted by effort score in descending order. Click a column heading to sort ascending or descending. Metrics per performance show a dash if no performance is available as a denominator; values that have not been recorded are also shown as —. Clicking the name of a production or the pencil icon Maintain figures in the project opens the project's BI tab. Export table hands the table over to the BI export.
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
- Resolve data gaps and estimates first.
- Check the period and previous-year comparison.
- Select a notable category in a chart.
- In Steering, sort the table by revenue, occupancy or effort.
- Open affected projects and review source data and circumstances.
- Only then draw conclusions or prepare reports.
Last updated on