GET/projects/api/v3/reporting/financial/trends/totals.json

Get per-period financial report totals

The summary rows under /trends. Returns one summary object per period over the whole filtered pool (not page-restricted): totals (pooled), plus averages and counts macro-aggregated over the groupBy dimension. Forces date grouping; pass exactly one non-date dimension in groupBy, which is also used as the implicit averageBy. startDate and endDate are required.

Query Params

  • Name
    startDate
    Type
    string
    Description

    start date

  • Name
    reportFormat
    Type
    string
    Description

    format of the report export; page/pageSize are ignored on exports

    Allowed values
    • csv
    • xlsx
  • Name
    orderMode
    Type
    string
    Description

    order mode

    Default
    asc
    Allowed values
    • asc
    • desc
  • Name
    orderBy
    Type
    string
    Description

    order by field; for /trends: name, <metricKey> (full-range aggregate), or <periodIndex>-<metricKey> (0-based, chronological)

  • Name
    endDate
    Type
    string
    Description

    end date

  • Name
    dateGranularity
    Type
    string
    Description

    date granularity (only when date in groupBy)

    Allowed values
    • daily
    • weekly
    • monthly
    • quarterly
    • yearly
  • Name
    averageBy
    Type
    string
    Description

    dimension the averages are computed per; must be one of the dimensions in groupBy. Defaults to the first groupBy dimension. date => average per period.

    Allowed values
    • company
    • project
    • projectbudget
    • tasklist
    • tasklistbudget
    • task
    • user
    • jobrole
    • timelog
    • allocation
    • expense
    • billablerate
    • costrate
    • date
  • Name
    pageSize
    Type
    integer
    Description

    number of items in a page

    Default
    50
  • Name
    page
    Type
    integer
    Description

    page number

    Default
    1
  • Name
    isReportDownload
    Type
    boolean
    Description

    generate a report export; also set by requesting the endpoint with a file extension (e.g. data.csv) instead of .json

    Default
    false
  • Name
    forceRefresh
    Type
    boolean
    Description

    bypasses the cache freshness probe and forces re-population (debounced server-side)

  • Name
    userIds
    Type
    array[integer]
    Description

    filter by user ids

    Format
    Comma separated values
  • Name
    tasklistIds
    Type
    array[integer]
    Description

    filter by tasklist ids

    Format
    Comma separated values
  • Name
    tasklistBudgetIds
    Type
    array[integer]
    Description

    filter by tasklist budget ids

    Format
    Comma separated values
  • Name
    taskIds
    Type
    array[integer]
    Description

    filter by task ids

    Format
    Comma separated values
  • Name
    projectIds
    Type
    array[integer]
    Description

    filter by project ids

    Format
    Comma separated values
  • Name
    projectBudgetIds
    Type
    array[integer]
    Description

    filter by project budget ids

    Format
    Comma separated values
  • Name
    metrics
    Type
    array[string]
    Description

    selected fact metrics to include

    Format
    Comma separated values
  • Name
    jobRoleIds
    Type
    array[integer]
    Description

    filter by job role ids (applies when grouping by jobrole)

    Format
    Comma separated values
  • Name
    include
    Type
    array[string]
    Description

    include

    Format
    Comma separated values
    Allowed values
    • companies
    • projects
    • users
    • teams
    • tasks
    • tasklists
    • projectbudgets
    • tasklistbudgets
    • timelogs
    • allocations
    • jobRoles
    • expenses
    • files
    • expenseCategories
  • Name
    groupBy
    Type
    array[string]
    Description

    group by dimensions (ordered chain)

    Format
    Comma separated values
    Allowed values
    • company
    • project
    • projectbudget
    • tasklist
    • tasklistbudget
    • task
    • user
    • jobrole
    • timelog
    • allocation
    • expense
    • billablerate
    • costrate
    • date
  • Name
    filter
    Type
    array[any]
    Description

    advanced filter (JSON)

    Format
    Comma separated values
  • Name
    expenseIds
    Type
    array[integer]
    Description

    filter by expense ids

    Format
    Comma separated values
  • Name
    companyIds
    Type
    array[integer]
    Description

    filter by company ids

    Format
    Comma separated values
  • Name
    allocationIds
    Type
    array[integer]
    Description

    filter by allocation ids

    Format
    Comma separated values

Responses

  • Code
    200
    Type
    object
    Schema
    Description
    200 OK
    AnalyticEngineTrendsTotalsResponse is the response for the trends/totals endpoint.
  • Code
    400
    Type
    object
    Schema
    Description
    400 Bad Request
    ErrorResponse defines how []Error should be marshaled to JSON.
  • Code
    409
    Type
    object
    Schema
    Description
    409 Conflict
    ErrorResponse defines how []Error should be marshaled to JSON.
  • Code
    500
    Type
    object
    Schema
    Description
    500 Internal Server Error
    ErrorResponse defines how []Error should be marshaled to JSON.

Examples

200 OK

AnalyticEngineTrendsTotalsResponse
{
  "data": [
    {
      "averages": {
        "averageBy": "string",
        "sources": {
          "additionalProp": {}
        }
      },
      "counts": {
        "additionalProp": 0
      },
      "granularity": "string",
      "period": "string",
      "totals": {
        "sources": {
          "additionalProp": {}
        }
      }
    }
  ],
  "meta": {
    "averageSpend": 0,
    "data": {},
    "limit": 0,
    "nextCursor": "string",
    "page": {
      "count": 0,
      "hasMore": true,
      "pageOffset": 0,
      "pageSize": 0
    },
    "prevCursor": "string",
    "totalCapacity": 0
  }
}
Download Swagger