Managing Views & Columns

Guide on how to manage columns & views in your screeners

Default Views

Each screener can have up to 12 views. Each view represent a set of columns and can have up to 20 columns. By Default, when you create a new screener, it will have 5 Views already created for you:

Overview

Provides an overview of different marketcap, volume, ROI metrics & high-level classifications

Long-Term ROI

Provides different Price % Change metrics on various timeframes (from 7 days to 5 years)

Calendar Years ROI

Provides different Price % Change metrics on specific years

Volume

Provide different metrics around volume aggregates, exchanges where the asset is trading, and number of markets tracked by Messari

Classifications

Provide different classification for assets, including the network(s) where the asset is deployed, the exchanges where it's trades as well as the sectors and tags from Messari taxonomy that help classify the assets.


Editing Views & Columns

Editing Columns from an Existing View or New View

To edit columns from an existing view or a new view you can either do it directly from a given column header, or from the column manager dialog, accessible on the far right of your screen table.

Zooming in on the column header capabilities, you can directly edit the column transformations from there:

You can also move columns placement by drag and dropping them as you see fit. If you want to bulk edit your columns set for a given view, the column manager is the best place to do so. Click on manage columns in the far right of your screen to access it.

From there you can directly add and remove columns, re-order them, and add transformations to selected metrics. When you're done making your changes, simply click on Update and they will be applied to your your view.


Similarly to the filters, you can also apply function to the different metrics. To do so select a metric in the middle column of the column manager.

From there, multiple functions are available for each metric:

  • On a specific date. You can select to a date in the past for which you want to see a given metric such as price or marketcap.
  • Transformation functions:
    • Sum: cumulative sum of a given over a defined time-period. Only available for cumulative metrics.
    • Average: the average of a given metric over a defined time-period
    • Min: minimum value of a given metric over a defined time-period
    • Max: maximum value of a given metric over a defined time-period
    • Median: median of a given metric over a defined time-period
    • Change: absolute change of a given metric over a defined time-period. Available for Price, Marketcap and other metrics.
    • % Change: percentage change of a given metric over a defined time-period. Available for Price, Marketcap and other metrics.

For each of these transformations, you can select from a large array of timeframe options settings:

  • Last X days or hours. Hour-based timeframes are only available for Volume and price metrics at the moment.
  • Specific Year (2022, 2021 etc...)
  • To date: Month-to-Date, Quarter-to-Date, Year-to-Date
  • Custom timeframes. Select an interval between two custom dates, or select a single date to apply a transformation since that date.

You can also set custom names for your columns by using the custom name toggle.

At any point you can delete existing columns, straight from the columns header or the column manager.


Editing Views and Creating New Views

A screen may contain up to 12 views. You can, rename them, duplicate them, export the view results into CSV and add your own custom views.

To rename, duplicate, export a view into CSV, or delete it, simply hover over a view name and select the action you want to perform

To add a new view, simply click on the new view button. You can then name your view and add columns as you see fit.