Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →hashgraph-online/filtering
Use when the user needs to filter data — whether in a structured query, a metric aggregation, or an attribute expression. Covers filter syntax, date handling, and best practices.
Passed 22 of 22 test cases with the skill, and 15 of 22 without it.
and 4 more in the full report
7 fixed15 passed either way0 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
One of 7 test cases the skill fixed. Same model, same prompt, with and without the skill.
I need to write a Honeydew metric SQL snippet that calculates total sales amount, but only counting orders that have a status of 'completed'. Could you give me the SQL expression for this filtered metric?
| Checked | Without skill | With skill |
|---|---|---|
| The SQL expression uses FILTER (WHERE orders.status = 'completed') | Missed | Passed |
| The expression uses SUM(orders.amount) or equivalent sum function | Passed | Passed |
The instructions your model reads when the skill loads.
Filtering restricts which rows contribute to a result. The same expression language applies across three contexts in Honeydew:
| Context | Where it appears | When it runs |
|---|---|---|
| Structured query | filters parameter in get_data_from_fields / get_sql_from_fields | Pre-aggregation |
| Metric aggregation | FILTER (WHERE ...) on an aggregation | During aggregation |
| Attribute expression | CASE WHEN ... END in attribute SQL | Per-row evaluation |
| Metric value filter | Metric expression in filters parameter | Post-aggregation |
entity.field = 'value'
entity.field > 100
entity.field >= 3 AND entity.field < 10
Operators: =, <, >, >=, <=, !=
You can compare an attribute to a constant or to another attribute. Cast mismatching types when comparing (e.g., entity.field::DATE).
entity.field = 'exact value'
entity.field IN ('val1', 'val2', 'val3')
entity.field ILIKE '%keyword%'
ILIKE is case-insensitive pattern matching (% = any characters, _ = one character)Use SEARCH when you don't know exact values and need to find possible matches.
test cases passed, vs 15 / 22 without
More skills from the same source and nearby in the registry, with their headline benchmark lift.