Shell Python Node PHP C# Ruby

Reporting & Analytics

Custom reporting & analytics is simple by utilizing our query language combined with the aggregate response value modifier functions and group by capabilities.

Using the ARM (API Relational Model) design of our software libraries, constructing complex reporting queries is simple and intuitive.

Example Query

Below is an example of an API query that can be used to generate a monthly and weekly report.

Average Volume by Day of Week

results = pl.Transaction.select(
        pl.attr.completed_date.dayofweek(),
        pl.attr.amount.avgsum()
    ).filter_by(
        pl.attr.status == 'complete',
        pl.attr.completed_date.year() == 2020
    ).group_by(
        pl.attr.completed_date.dayofweek()
    ).all()
const results = await pl.select(
        pl.Transaction.completed_date.dayofweek(),
        pl.Transaction.amount.avgsum()
    )
    .filterBy(
        pl.Transaction.status.eq('complete'),
        pl.Transaction.completed_date.year().eq(2020)
    )
    .groupBy(pl.Transaction.completed_date.dayofweek())
var results = await pl.Transaction
    .Select(
        pl.Attr.completed_date.dayofweek(),
        pl.Attr.amount.avgsum()
    )
    .FilterBy(
        pl.Attr.status.eq("complete"),
        pl.Attr.completed_date.year().eq(2020)
    )
    .GroupBy(pl.Attr.completed_date.dayofweek())
    .AllAsync();
dayofweek(completed_date) avgsum(amount)
sunday 24960.22
monday 8060.74
tuesday 15732.97
wednesday 15732.97
thursday 26703.59
friday 29253.64
saturday 25357.85