Computed Views

You can write Python code in Computed Views to pull data from multiple sources (both in Seal and externally), perform aggregations, and output tables and charts.

For general information about writing code in Seal, see the Scripts docs

Each time you execute the code, a Run is produced, containing an output CSV file. CSV files are inherently self-contained and versioned, and can store large amounts of data performantly. Each Run stores an immutable snapshot of your aggregated data at that point in time.

Within Seal you can also configure charts to visualise the CSV data.

Output

To output data for the Computed View, assign a dataframe to the special variable computed_view_data. This will then be viewable in a table (plus any configured charts), and downloadable as a CSV. For example:

import pandas
import random
data = [
    {
        'Machine': 'XXXX',
        'Reading': random.randrange(1,100)
    },
    {
        'Machine': 'YYYY',
        'Reading': random.randrange(1,100)
    },
    {
        'Machine': 'ZZZZ',
        'Reading': random.randrange(1,100)
    },
]
computed_view_data = pandas.DataFrame.from_records(data)