← BACK TO ALL USE CASES
Dashboards & ReportingAutomated Calculations

Build a live scoreboard for an internal contest

Context and Challenge

A technical community team was running an internal contest where employees earned points for different types of contributions. Each type of content had its own scoring rule — for example, one contribution could be worth 10 points and another 5.

The team needed to combine these rules with contributor activity and calculate individual scores, team totals, and rankings.

Result

The contest results are calculated automatically from the contributor data and predefined scoring rules. As new contributions are added or existing data changes, the same calculation logic can be applied again to update individual points, team totals, and the current ranking without rebuilding the scoreboard manually.

How it is built

  1. The contest rules are stored in a table together with the point value assigned to each type of contribution.
  2. Table Transformer uses SQL to combine these rules with contributor data, calculate points, summarize results by team, and determine the current ranking.
  3. Table Toolbox is used to combine the tables and transformation logic on the Confluence page.

THE APP MACROS USED

  • Table Transformer
  • Table Toolbox
← BACK TO ALL USE CASES

Similar use cases

Dashboards & Reporting

Track 40+ Jira projects across multiple business units in one custom report

Consolidate live data from 40+ Jira projects into one cross-project report that makes status differences and overdue work visible across teams.

VIEW CASE → Dashboards & Reporting

Build a data-backed dashboard for 1-on-1 meetings

Bring time-tracking and Jira data into one Confluence page to use as a shared reference during 1-on-1 meetings.

VIEW CASE →

Level up the way your team works in Confluence

Turn your Confluence space into a single source of truth, reduce manual work and copy-paste, and create the visibility your team and stakeholders need.

TRY FREE (opens in a new tab)