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.
Let's make a Line chart of the number of Ethereum transactions per day.
- Click on
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
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.
- Under the
ethereum_transactionsfield, scroll down and select
block_timestamp, which needs to be grouped
Updated about 1 year ago