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

  • 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

PreviousInsightNextDashboards

Last updated