Worksheets
Using GeniiData, you can query blockchain data using SQL, and the results can be used to create amazing data visualizations using our charts and graphs.
- Recent: Displays recently-viewed Worksheets list
- My Worksheets: Displays all created folders and Worksheets
- Folders: Displays the folder list. Click on 'Folders' to view the embedded Worksheets.
![](/docs/assets/Untitled-30.bab5d653.png)
Search
- Click Search to search for Worksheets, Folders, and Dashboard.
- Click the search result to enter the corresponding operation page.
![](/docs/assets/Untitled-3.4495c613.png)
![](/docs/assets/Untitled-4.f6abd158.png)
Folders
Add folder
- Click on +Folder, enter the Folder name, and Click Create Folder.
![](/docs/assets/Untitled-5.7462a232.png)
Modify and Delete Folders
- Click the folder name. Users can modify or delete the folder name in the displayed drop-down list.
- A double-check is performed when deleting to confirm the action.
- If Delete is selected, the folder is deleted.
- If Cancel is selected, the folder is not deleted, and the pop-up is closed.
![](/docs/assets/Untitled-8.446a0a3f.png)
![](/docs/assets/Untitled-9.15c1d747.png)
Add Worksheets
- Click on +Worksheets to enter the worksheet operation interface.
![](/docs/assets/Untitled-10.297f648c.png)
- Worksheets will be split up into four parts
![](/docs/assets/Untitled-11.de307f4f.png)
Worksheets and Datasets
- Worksheets
![](/docs/assets/Untitled-12.2375df7f.png)
- Datasets
![](/docs/assets/Untitled-13.3dee6e11.png)
- Currently supported chain networks: https://geniidata.notion.site/Chains-00f257dfd8fa46cb9e0be4b688733b40
![](/docs/assets/Untitled-14.9b986115.png)
- Decoded Projects: Supporting contract data from opensea, x2y2, etc
![](/docs/assets/Untitled-15.6d7146d5.png)
- Common Data: Supporting ETL related to the NFT marketplace, such as trades & price
![](/docs/assets/Untitled-16.e53a0a8f.png)
- My Dataset: All the tables submitted by the user can be viewed in the My Dataset
![](/docs/assets/Untitled-17.8ec7a687.png)
- Double-click the table name or field name to send the corresponding information to the SQL input box
![](/docs/assets/Untitled-17.8ec7a687.png)
SQL Input Box
- Support Spark SQL
- Support SQL layout in one click (Format)
- Support light/dark mode
Result & Chart
Result
- Click run ( or ctrl+enter ) to view the execution progress
![](/docs/assets/Untitled-19.460eadf9.png)
- The data will be displayed in the resulting command if the query succeeds.
- Data Results can be downloaded in CSV format.
![](/docs/assets/Untitled-20.2cb02f4d.png)
- The results can be added to the Dashboard.
Configuration items:
- Displays the execution time for SQL
- Time of the last execution
- Adjustable table Title, field name, decimal place, thousandth place, etc
![](/docs/assets/Untitled-21.826e3b3d.png)
Chart
- Support charts such as Bar, Horizontal Bar, Area, Scatter, Line, Pie and Counter
![](/docs/assets/Untitled-22.243c4bb5.png)
Example: Bar Chart
- Click on Chart Type to quickly switch the chart type (Bar, Area, Scatter, Line)
![](/docs/assets/Untitled-23.d5aab3a3.png)
- The chart can be quickly added to the Dashboard.
![](/docs/assets/Untitled-24.dc7d7a58.png)
- Data
- Support adjusting chart names
- X-axis and Y-axis are mandatory, and multiple columns can be added to the Y-axis (click on +Add column)
- Group by (optional)
![](/docs/assets/WechatIMG1449.5681971f.jpeg)
- Appearance
- X-axis or Y-axis names can be added.
- The X-axis is in reverse order. By default, the data is in positive order.
- Enabling Right Y-axis
- Double Y-axis
- Line and column mix data
![](/docs/assets/WechatIMG1450.83dd725d.jpeg)
- Advanced features
- Support changing indicator names and graphs
- Supports alignment adjustment (left alignment by default). If you select the right alignment, the right Y-axis will be enabled first.
- Support changing the indicator color
![](/docs/assets/WechatIMG1451.6643ee62.jpeg)
- Chart options
- Show Legend is opened by default.
- Enable stacking, Normalize to percentage, and Show data labels are closed by default
![](/docs/assets/WechatIMG1452.3a46f465.jpeg)
- Delete Chart
- Users can delete charts at the end of the configuration items.
- Double confirmation is required when deleting the chart
- Note: If the chart is referenced by the Dashboard, it cannot be deleted. It can be deleted only after Chart is unbound from the Dashboard.
- following the path by clicking"Worksheets"->"Chart" -> "Add to dashboards"
- Users can delete charts at the end of the configuration items.
Worksheets Name Drop-down List
- Support adjusting the name of the worksheet
- Quickly moving worksheets into folders.
- Support replicating the current worksheets
- Support deleting worksheets. Double confirmation is required when deleting.
- Displaying
- Command/Ctrl + Ente — Run query
- ⌘ + shift + O / ctrl + alt + O — Format query
![](/docs/assets/Untitled-29.eeb64ad9.png)