Analytics & Automation

Analytics Studio & Automation

15 built-in reports, QueryStudio no-code report builder, and a two-tier automation system — from simple formulas to Python-like scripts.

15 built-in reports QueryStudio (no-code) Expr formulas Starlark scripts 36 ready scripts

QueryStudio — Report builder

Create custom reports without SQL or programming through a 7-step wizard.

1

Data source

Choose entity: orders, invoices, customers, stock...

2

Columns and fields

Drag the required fields from 50+ available attributes.

3

Filters and aggregations

GROUP BY, SUM/AVG/COUNT, ROLLUP subtotals.

4

Schedule & email

Automatic sending on schedule (cron) to email.

Analytics Studio
Automation Studio

Automation Studio — two-tier system

Two levels of automation for different complexity — from one-line formulas to full Python-like scripts with access to business context.

Tier-1: Expr formulas

Fast calculations for pricing rules and business logic. Compile-cached, <1ms execution.

price * (1 - discount/100) * quantity

Tier-2: Starlark scripts

Python-like sandbox for complex logic. MaxSteps=1M, Timeout=500ms. Safe execution.

def calculate_bonus(sales, target):
  if sales > target * 1.2:
    return 0.15
  return 0.05

36 ready-made scripts across 11 context types

Pricing · Inventory · Accounting · Orders · Invoices · HR · Procurement · Manufacturing · Sales · Exchange rates · Reports

Revenue planning & cash flows

Financial analytics automatically aggregated from contracts and orders — no manual data entry.

Revenue planning

Auto-generated from contract on activation. Planned vs actual revenue per time interval. Feeds into P&L report.

Cash flow forecast

Expected payment date = revenue date + credit_days. Weekly receipt forecast. Overdue payment tracking.

Revenue and Cash Flow