# Query data across accounts belonging to an organisation

Use Sigma with Organisations to query multiple accounts.

If you use [Organisations](https://docs.stripe.com/get-started/account/orgs.md), you can use [Sigma](https://docs.stripe.com/stripe-data/how-sigma-works.md) to run queries across multiple accounts. These queries can provide insight into your customers and payments across your entire business.

## Get started

Before you begin, complete the following steps:

1. [Create an organisation](https://docs.stripe.com/get-started/account/orgs/build.md), adding all the accounts you want to include in your queries.
1. Enable Sigma in each account you want to include in your queries.

To run and execute Sigma queries, you must be assigned an organisation-level role with permissions to view reports, such as [Analyst](https://docs.stripe.com/get-started/account/teams/roles.md).

## Run Sigma queries across multiple accounts

To run Sigma queries that span multiple accounts in your organisation, follow these steps:

1. From the Dashboard, use the account picker to select your organisation. Expand **Reporting**, then click [Sigma](https://dashboard.stripe.com/org/sigma/queries).

1. Write a new query, choose from saved queries, or select from the list of templates.

1. To specify the accounts you want to run your query on, click **Run on accounts**, then **Select accounts**.

1. Run the query across the accounts you selected.

### Return results for each account

By default, queries return results that include data across all selected accounts. To return results for each account, you can group results by `merchant_id`. For example, the following query returns the sum of PaymentIntents in the last 14 days for each account and currency:

```sql
select
  merchant_id,
  currency,
  sum(amount) as total_payment_volume_last_14d
from payment_intents
where created >= date_add('day', -14, current_date)
group by 1, 2
```

| `merchant_id`        | `currency` | `total_payment_volume_last_14d` |
| -------------------- | ---------- | ------------------------------- |
| acct_orWziM4j7CiRL8J | USD        | 4934823                         |
| acct_orWziM4j7CiRL8J | CAD        | 2235991                         |
| acct_orWziM4j7CiRL8J | GBP        | 1870021                         |
| acct_orWziM4j7CiRL8J | EUR        | 9008212                         |

### Filter accounts within a query

To use the `merchant_id` field to filter results to specific accounts directly in your query, add a `WHERE merchant_id = 'acct_id'` clause. For example, the following query returns the total volume of payments in a specific account:

```sql
select
  currency,
  sum(amount) as total_payment_volume_last_14d
from payment_intents
where created >= date_add('day', -14, current_date)
AND merchant_id in (
  'acct_d8upQPPBbFtSIe1',
  'acct_1fCSEPk3waoDZox'
)
group by 1
```

| `currency` | `total_payment_volume_last_14d` |
| ---------- | ------------------------------- |
| USD        | 8833809                         |
| CAD        | 9008212                         |