Transactions Dashboard 
======================

This dashboard provides a real-time view of the transactions in yearn-treasury's database, displaying columns such as timestamp, block, hash, token, addresses, and associated metadata (address nicknames, amount, price, and value in USD).

Key Features
------------

1. Time Range Controls
- The dashboard honors Grafana’s built-in time range filter.  
- You can set a custom time window or pick from Grafana’s presets, such as “Last 24 hours.”  
- The query automatically adjusts to include transactions in the specified time range.

2. Chain Filter
- A variable-driven filter is provided for selecting one or more blockchain networks.
- “All” option is available, which fetches transactions from any chain.

3. Token Filter
- A multi-value token filter allows you to restrict transactions to specific token(s).  
- Selecting “All” includes every token in that time window.
- If multiple tokens are selected, the underlying SQL uses an `IN (...)` clause to retrieve transactions for those tokens only.

4. From Address Filter
- Filters transactions by “from” address or address nickname.  
- Selecting “All” includes transactions from all addresses.

5. To Address Filter
- Similar to the “From Address” filter, this variable narrows down transactions by the “to” address or nickname.
- “All” option pulls all outgoing transactions regardless of destination.

6. Transactions Table
- Displays each transaction in rows with key data columns:  
  - **timestamp**: The date/time (in UTC) when the transaction was recorded.  
  - **block**: The block height at which the transaction occurred.  
  - **hash**: A clickable transaction hash (if the panel is configured with a link) or raw hash data.  
  - **token**: Symbol of the token transferred.  
  - **from** / **from nickname**: The originating address and its nickname (if any).  
  - **to** / **to nickname**: The destination address and nickname (if any).  
  - **amount**: Quantity of tokens transferred in the transaction.  
  - **price**: Price per token (in USD) at the time of transfer.  
  - **value usd**: The total value of the transfer in USD (amount × price).  

7. Sorting & Ordering
- The table is sorted by **timestamp** in descending order by default, showing the newest transactions on top.
- You can adjust sorting or ordering by clicking on the column headers if needed.

Usage Tips
----------
- **Filter Combinations**: You can combine chain, token, and address filters to isolate specific events or activity.  
- **“All” Selections**: Selecting “All” in each filter bypasses that dimension, ensuring a broad dataset.  
- **Time Shifting**: Grafana’s time range picker allows you to analyze historical data (e.g., last month, last quarter) to spot trends in token activity.

Conclusion
----------
This dashboard offers a comprehensive overview of Yearn's value transfers. By leveraging Grafana’s powerful variable filters and a direct SQLite data source, users can drill down into specific transactions over any chosen time range, chain, token, or addresses. The result is a dynamic, flexible workflow for analyzing and monitoring token movement in near-real-time.