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