In this optional challenge you will add a new card to your dashboard, and connect a filter to it.
You should:
-
Pick a question
-
Create a Cypher query that answers that question
-
Use natural language or Cypher to create a card that answers that question
-
Connect a filter to the card so viewers can change a key value without editing the query
Pick a question
Choose a question that makes sense for your graph. For example:
-
Which actors have appeared in more than $min_movies movies?
-
Which movies has $actor_name appeared in, and what is the average rating?
-
Which users have rated more than $min_ratings movies, and what genres do they prefer?
Create a Cypher query
Open Query in the Aura Console and develop your Cypher before adding it to a card.
Natural language to Cypher
You can use natural language to find the right query pattern. For example, you could ask: Which genres have the highest average movie ratings? and use the generated Cypher as a starting point for your dashboard card.
Here are some example queries you could develop:
MATCH (p:Person:Actor)-[:ACTED_IN]->(m:Movie)
WHERE p.name = $actor_name
RETURN m.title AS title,
m.year AS year,
m.imdbRating AS imdb_rating
ORDER BY m.year DESC;MATCH (u:User)-[r:RATED]->(m:Movie)-[:IN_GENRE]->(g:Genre)
WHERE u.name = $user_name
RETURN g.name AS genre,
count(m) AS movie_count,
round(avg(r.rating), 1) AS avg_rating
ORDER BY movie_count DESC;Rating on the relationship
The rating property lives on the RATED relationship, not on the Movie node. Always alias the relationship (-[r:RATED]→) so you can access r.rating in RETURN and WHERE.
Add the card to your dashboard
When adding a card:
-
Set a descriptive title (for example, "Actor filmography" or "Genre preferences by user").
-
Set Visualization type to Table — this is a good default for parameterized queries because you can see all returned columns clearly.
-
Paste your Cypher query (with the
$parameter_nameplaceholder, not the hardcoded test value). -
Click Run inside the editor to confirm it returns data with the default parameter value.
-
Click Save changes.
Add a filter
Add filter and set the filter parameters, before updating your card query to use the new parameter.
Test the filter by changing the value and confirm the card updates.
For reference, the Filters and parameters documentation covers filter types and the full parameter workflow.
Summary
In this optional challenge you added a new card to your dashboard, and connected a filter to it.
In the next lesson you will explore how to organize yor dashboard, apply styling to graph cards, and how to export and import dashboards.