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.

Search ​

• Click Search to search for Worksheets, Folders, and Dashboard.
• Click the search result to enter the corresponding operation page.

Folders ​

Add folder ​

• Click on +Folder, enter the Folder name, and Click Create Folder.

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.

Add Worksheets ​

• Click on +Worksheets to enter the worksheet operation interface.

• Worksheets will be split up into four parts

Worksheets and Datasets ​

• Worksheets

• Datasets

• Currently supported chain networks: https://geniidata.notion.site/Chains-00f257dfd8fa46cb9e0be4b688733b40

• Decoded Projects: Supporting contract data from opensea, x2y2, etc

• Common Data: Supporting ETL related to the NFT marketplace, such as trades & price

• My Dataset: All the tables submitted by the user can be viewed in the My Dataset

• Double-click the table name or field name to send the corresponding information to the SQL input box

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

• The data will be displayed in the resulting command if the query succeeds.
• Data Results can be downloaded in CSV format.

• 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

Chart ​

• Support charts such as Bar, Horizontal Bar, Area, Scatter, Line, Pie and Counter

Example: Bar Chart ​

• Click on Chart Type to quickly switch the chart type (Bar, Area, Scatter, Line)

• The chart can be quickly added to the Dashboard.

• 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)

• 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

• 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

• Chart options
  • Show Legend is opened by default.
  • Enable stacking, Normalize to percentage, and Show data labels are closed by default

• 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"

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