Build an aggregations page

Step 1: Add a new dashboard page

Open your dashboard in Dashboards and click New page. Name it something that signals the audience or purpose — for example, "Content metrics", "Director stats", or "Genre overview".

Step 2: Add cards to the page

Add at least three cards to the page, each with a different chart type.

Use the example queries below or write your own.

MATCH (m:Movie)
RETURN count(m) AS total_movies;

MATCH ()-[r:RATED]->()
RETURN count(r) AS total_ratings;

Bar chart

Add a card that compares a metric across categories. Bar charts are the clearest choice when you have 3–15 categories and a single numeric value to compare.

MATCH (m:Movie)-[:IN_GENRE]->(g:Genre)
WHERE m.imdbRating IS NOT NULL
RETURN g.name                        AS genre,
       round(avg(m.imdbRating), 2)   AS avg_imdb,
       count(m)                      AS movie_count
ORDER BY avg_imdb DESC
LIMIT 15;

Line chart

Add a card that shows a trend over an ordered dimension. Line charts suit time-series or year-by-year data.

Example queries for line charts:

MATCH (m:Movie)
WHERE m.year IS NOT NULL
RETURN m.year AS year, count(m) AS releases
ORDER BY year;

MATCH (m:Movie)
WHERE m.year IS NOT NULL AND m.imdbRating IS NOT NULL
WITH (m.year / 10) * 10 AS decade, m.imdbRating AS rating
RETURN decade,
       round(avg(rating), 2) AS avg_imdb,
       count(*) AS total
ORDER BY decade;

Text card

Add a Text card that explains what this page is for. A viewer who lands on this page without context needs to know what question it answers and what the numbers mean.

Write two or three sentences in plain language. For example:

## Content performance overview

This page summarises movie volume, release trends, and audience ratings across genres.

**Data source:** GraphAcademy Movies recommendations dataset — approximately 9,000 movies and 100,000 ratings.

Step 3: Arrange the layout

Drag the cards using the six-dot handle on each card so the layout reads top-to-bottom in order of importance:

Read the page as a viewer would: does it tell a coherent story without any other instructions?