Possible to perform time series aggregation in workshop

Ask the Community
1

I’m looking to perform a time series aggregation in workshop. Basically, I want to sum-up time series data over a specific period of time and display it in a metric card. Is this possible?

I would do it in quiver, but the aggregation card does not have the ability to refresh automatically, which our use case needs.

2

As far as I know making calculations over time series and specifically over a selected time range is not possible in the current state of Workshop.

The most reliable way I have been getting around this is using Typescript functions. Giving the objects that hold the time series as well as the start and end times as inputs and returning the calculation, then using the function to back a variable.

3

How can I access time series data in a function?

4

This only works if you have your time series as a property of your object, and then you access it the same way you would access any other property in Typescript.

Please take the following code with a grain of salt. It works but it doesn’t follow any good practices.

@Function()
    public async yourFunction(
        yourOS: ObjectSet<T>,
        start: Timestamp,
        end: Timestamp
    ): Promise<Double> {
        const saveAgg: number[] = [];
        await Promise.all(yourOS.all().map( async (obj) => {
            const avg = (await obj.yourTimeSeriesProperty?.timeRange({min: start, max: end})
                .aggregate()
                .overEntireRange()
                .mean()
                .compute())?.mean!
            saveAgg.push(avg)
        }))

        const res = saveAgg.reduce((total, obj) => total + obj || 0) / saveAgg.length;
        return res || -1;
    }

This is how I do an average for a specific time range for ALL the time series of an Object Set, it can be 1 or multiple. Another option would be to return a Map with the aggregation of each Object and the Object itself.