Implementation

To create a simple workflow with easy-to-use interface, we use Metabase. It handles the complexity of joins, aggregations, and more, freeing the users to focus on uncovering their next insight, rather than picking through long SQL.

Example

Let's make a Line chart of the number of Ethereum transactions per day.

1. Click on Create and select New chart.

The image above shows users how to create a new chart based on Steps 1 and 2.
2. Select Ethereum. A drop-down menu will appear.
3. Select the data table ethereum_transactions

The gif above demonstrates Steps 1 to 3, the process of getting to ethereum_transactions for the purpose of this guide.
4. In the ethereum_transactions table, there is one record for each transaction, which means you can directly count the number of records and group by day. Click Summarise in the upper right corner, and then pick Count of rows.

5. Under the ethereum_transactions field, scroll down and select block_timestamp, which needs to be grouped Day