Filtering Rows
Use these when you only want to see a subset of your data — rows that meet a condition, the most recent entries, or a sorted view.
Filter by Value — DF_FILTER_BY_VALUE
Keep only the rows where one or more conditions are met.
Use this when: you want to show readings that cross a threshold, or only show data for a specific device or status.
Available operators: eq (equals), ne (not equal), gt (greater than), lt (less than), gte (greater than or equal), lte (less than or equal).
Before
Code
After — keeping rows where temperature > 30
Code
Code
You can combine multiple conditions. Set "match": "any" to keep rows where at least one condition is true (default is "all" — every condition must be true).
Sort — SORT
Order the rows of an array by a column, ascending or descending.
Use this when: you want to show the highest or lowest values first, or put data in chronological order.
Before
Code
After — sorted by kwh descending (highest first)
Code
Code
Limit — LIMIT
Keep only the first N rows of your data.
Use this when: you only need the top results — for example, the 10 most recent readings, or the top 5 devices by consumption.
Before
Code
After — keeping only the first 3 rows
Code
Code
Tip: Pair with Sort first to get the top 3 by a value, not just the first 3 in the list.
Filter by Query — DF_FILTER_BY_QUERY
When a panel pulls from more than one query, keep or drop the rows that came from a specific query.
Use this when: you've combined several data sources into one panel and want to show — or hide — only the rows that originated from one of them.
Use this after combining queries (see Combining Data Sources), where each row is tagged with the query it came from (e.g. A, B).
Before — rows from queries A and B
Code
After — keeping only query A
Code
Code
Set "mode": "exclude" to drop that query's rows instead.