Performing Billing Queries and Reviewing Results

On the Billing tab in the Data Explorer, you can use the Query Builder to configure and perform queries against the Billing data for your Organization in m3ter. The Query Builder is designed to let you quickly set up and submit a query that returns precisely the right data set to serve your current analytical purposes. You can then review the data in either a flat Data Table or a Pivot Table format.

This topic explains how to work successfully in the Data Explorer to configure and perform queries against your Billing data and review returned data.

Building and Performing a Billing Data Query

To submit queries for Billing data and review returned data:

1. Select Analytics>Data Explorer. The Data Explorer opens with the Usage tab selected.

2. Select the Billing tab. You can build the specific query you want to perform against billing data collected for your Organization.

3. In the Select period section, define a period to retrieve billing data for:

  • Time period. Use the drop-down list to select a period for which you want to retrieve billing data. Today is the default. If you want to select a specific period, you can use Custom.

  • Start date and End date. If you have selected Custom for the query Time period, these date/time fields will be enabled. You can use calendar popups to select the start and end dates/times for the period you want to query.

Tip: Timezone for Query Start and End Dates/Time? The Start date and End date fields will show the timezone you've set for your Organization. See Managing your Organization.

4. In the Apply filters section, enter the details of any filters you want to apply to the billing data returned for your query:

  • Line item types. Filter on line item types:

    • All Line item types. Data will be returned for all Bill line item types.

    • Selected values. Use the drop-down to select the Bill line item types for which you want to return Billing data.

  • Accounts. Filter on Accounts:

    • All Accounts. Data will be returned for all Accounts for which Bills have been created.

    • Selected values. Use the drop-down to select the Account Code of those Accounts for which you want to return Billing data.

  • Products. Filter on Products:

    • All Products. Data will be returned for all Products for which a Bill has been created.

    • Selected values. Use the drop-down to select the Products for which you want to return Billing data.

In this example we have:

  • Defined a Custom time period of one month. The Organization Timezone is set to UTC.

  • Selected a single Account and a single Product to return Billing data for.

  • Selected for two line item types in the returned Billing data.

5. Select Perform Query. The query executes and the resultant data is loaded into the data tables.

Important: Response too Large Error! If the response payload for your query is >10MB, this exceeds our limit and you'll receive an error message to inform you. You can either use the available filters to further limit the query result set and re-run your query or use the Export button to download the current results in a .csv formatted file - see Exporting Query Results.

Reviewing Billing Data Query Results in a Data Table

You can review the Billing data returned for your query in a Data table:

Tip: Toggle Data Elements? The results set for a Billing query contains numerous data elements. For ease of use, you can select the book icon at the left side of the Data Table and use the check boxes to toggle on and off which Billing data elements are shown in the table.

Reviewing Billing Data Query Results in a Pivot Table

You can review the Billing data returned for your query in a Pivot table:

Tip: Saving Billing Queries? You can save, update already saved, and re-use saved Billing queries. You can also load pre-configured Standard Queries directly into the Query Builder. See Saving, Updating, and Re-Using Queries.

Next: Performing Prepayments Queries and Reviewing Results