Monthly analytics

In the Cost overview subsection, you can explore the monthly costs on the following levels:

  1. Account — overall costs distribution by subscription of your account.
  2. Subscription — costs distribution by resources (resource categories) of a subscription.
  3. Resource category — costs distribution by resources of a resource category. Available only if the subscription's consumption data contains resource category information.

For every subscription, the displayed data is collected from daily consumption statistics for an individual period limited by the corresponding billing days.

For example, an account has two subscriptions: for the Microsoft Azure service, the billing day = 1, and for the Microsoft 365 service, the billing day = 5. In this case, the displayed data for the 6 billing periods includes the following different periods: for the Microsoft Azure service — 01.01.2020 – 30.06.2020, and for the Microsoft 365 — 05.01.2020 – 04.07.2020.

In this article:

Overall analytics for subscriptions

To view overall monthly analytics for subscriptions:

  1. In the navigation menu, select Analytics > Cost overview. A page with data for the default filters is displayed.
  2. In the Subscription list, make sure All subscriptions is selected.

  3. In the Granularity list, make sure Monthly is selected.

  4. In the Period list, select the period for the displayed data:

    • 3 billing periods — default.

    • 6 billing periods.

    • 12 billing periods.

    • Custom billing period — a period of up to 12 consequent billing periods limited by the billing days. To select a custom billing period:

      1. In the Period field, click the dates range. The calendar with the list of months is displayed.
      2. Click the first month of the required period. The selected month is highlighted.
      3. Click the last month of the required period. The months within the period are highlighted.
      4. In the calendar, click OK. In the Period field, the dates of the selected billing period are displayed as "First month YYYY — Last month YYYY".
  5. Wait until the data is loaded and displayed.

The cost structure for all subscriptions of an account is displayed in the following sections:

  • General cost structure — a doughnut chart where each segment shows the proportional value of costs per subscription. The segments have labels with the component names and percentage values.

    To view the cost of a subscription, hover the mouse pointer over the corresponding sector of the General cost structure chart. The tooltip with the name and cost with up to two decimal places is displayed.

    A subscription may not be displayed in the diagram if its cost is less than 1% of the total cost.


    To filter the data by a subscription:

    1. Click the corresponding sector of the General cost structure chart. The context menu is displayed.
    2. In the context menu, select Filter by subscription.
      As a result:
      • The other sectors of the General cost structure chart become faded.
      • The Cost structure chart and the Summary table display the data for the selected subscription only.

    To reset filtering by a subscription:

    1. Click the corresponding sector of the General cost structure chart. The context menu is displayed.
    2. In the context menu, select Cancel filter.

  • Cost Dynamics — the cost of all subscriptions for the two previous billing periods and the percentage of the growth rate.

  • Monthly cost structure — a stacked bar chart that displays the monthly dynamics of costs per subscription for the selected period.

    To view the costs for a certain month, hover the mouse pointer over the corresponding column of the Monthly cost structure chart. The tooltip with the total cost and the costs per every subscription with up to two decimal places is displayed.

    To exclude a subscription from the Monthly cost structure chart, click its name in the chart legend. As a result, the Monthly cost structure chart is updated and does not display the excluded subscription.

    To view the consumed data for only one subscription in the Monthly cost structure chart, you can use filtering in the General cost structure chart (see above).

  • Summary — a table of costs per subscription for the selected period.

    If the data in the table does not fit in width, use horizontal scrolling.

    The Summary table includes the following columns:

    • Name — the description of a subscription.
    • <Month-year> — the costs for a subscription per month.
    • Total — the total costs for a subscription for the selected period.

    The sum of costs for a subscription is displayed in the Total column, and the sum of costs of all subscriptions for a month is displayed in the Total row. At the intersection of the Total row and column, the grand total of costs for the selected period is displayed.

    The table supports the sorting of the rows by every column. By default, the Total column is used for descending sorting.

    The Name column also supports filtering by partial-match searching. To filter the table rows, start entering the search key in the Search by name field.

    Depending on the available data, the rows of the table can have the following grouping levels:

    1. Resource category.
    2. Resource.

    By default, the levels are collapsed. To expand a level, click  in the required row.

Analytics for a single subscription

To view monthly analytics for a single subscription:

  1. In the navigation menu, select Analytics > Cost overview. A page with data for the default filters is displayed.
  2. Select the required subscription by doing any of the following:
    • In the Subscriptions list, select the required subscription.
    • Select the required subscription in the doughnut chart with all subscriptions:
      1. In the General cost structure doughnut chart with all subscriptions, click the sector that represents the required subscription. The context menu is displayed.
      2. In the context menu, select Go to subscription analytics.

  3. In the Granularity list, make sure Monthly is selected.

  4. In the Period list, select the period for the displayed data:

    • 3 billing periods — default.

    • 6 billing periods.

    • 12 billing periods.

    • Custom billing period — a period of up to 12 consequent billing periods limited by the billing days. To select a custom billing period:

      1. In the Period field, click the dates range. The calendar with the list of months is displayed.
      2. Click the first month of the required period. The selected month is highlighted.
      3. Click the last month of the required period. The months within the period are highlighted.
      4. In the calendar, click OK. In the Period field, the dates of the selected billing period are displayed as "First month YYYY — Last month YYYY".

    • Custom calendar period — a period of up to 12 consequent months. To select a custom calendar period:

      1. In the Period field, click the dates range. The calendar with the list of days is displayed.
      2. Click the first day of the required period. The selected day is highlighted.
      3. Click the last day of the required period. The period within the days is highlighted.
      4. In the calendar, click OK. In the Period field, the dates of the selected billing period are displayed.
  5. Wait until the data is loaded and displayed.

The cost structure for the selected subscription of an account is displayed in the following sections:

Resource categories are displayed only if the consumption data includes this information. Otherwise, only the resource data is available.

  • General cost structure — a doughnut chart where each segment shows the proportional value of costs per resource (resource category). The segments have labels with the component names and percentage values.

    To view the cost of a resource (resource category), hover the mouse pointer over the corresponding sector of the General cost structure chart. The tooltip with the name and cost with up to two decimal places is displayed.

    A resource (resource category) may not be displayed in the diagram if its cost is less than 1% of the total cost.


    To filter the data by a resource category:

    1. Click the corresponding sector of the General cost structure chart. The context menu is displayed.
    2. In the context menu, select Filter by resource category.
      As a result:
      • The other sectors of the General cost structure chart become faded.
      • The Cost structure chart and the Summary table display the data for the selected resource category only.

    To reset filtering by a resource category:

    1. Click the corresponding sector of the General cost structure chart. The context menu is displayed.
    2. In the context menu, select Cancel filter.

    To filter the data by a resource, click the corresponding sector of the General cost structure chart. To reset filtering by a resource, click the corresponding sector of the General cost structure chart one more time.

  • Cost Dynamics — the cost of the selected subscription for the two previous billing periods and the percentage of the growth rate.

  • Monthly cost structure — a stacked bar chart that displays the dynamics of costs per resource (resource category) for the selected period.

    To view the costs for a certain month, hover the mouse pointer over the corresponding column of the Monthly cost structure chart. The tooltip with the total cost and the costs per every resource (resource category) with up to two decimal places is displayed.

    To exclude a resource (resource category) from the Monthly cost structure chart, click its name in the chart legend. As a result, the Monthly cost structure chart is updated and does not display the excluded resource (resource category).

    To view the consumed data for only one resource (resource category) in the Monthly cost structure chart, you can use filtering in the General cost structure chart (see above).

  • Summary — a table of costs per resource (resource category) for the selected period.

    If the data in the table does not fit in width, use horizontal scrolling.

    The Summary table includes the following columns:

    • Name — the description of a resource (resource category).
    • <Month-year> — the costs for a resource (resource category) per month.
    • Total — the total costs for a resource (resource category) for the selected period.

    The sum of costs for a resource (resource category) is displayed in the Total column, and the sum of costs of all resources (resource categories) for a month is displayed in the Total row. At the intersection of the Total row and column, the grand total of costs for a subscription for the selected period is displayed.

    The table supports the sorting of the rows by every column. By default, the Total column is used for descending sorting.

    The Name column also supports filtering by partial-match searching. To filter the table rows, start entering the search key in the Search by name field.

    For resource categories, in the rows, data is grouped by resources and the rows are collapsed by default. To view information about resources, click  in the required row.

Analytics for a single resource category

Viewing analytics for a single resource category of a subscription is available only for subscriptions that have this information in consumption statistics.

To view monthly analytics for a single resource category of a subscription:

  1. In the navigation menu, select Analytics > Cost overview. A page with data for the default filters is displayed.
  2. Select the required subscription by doing any of the following:
    • In the Subscriptions list, select the required subscription.
    • Select the required subscription in the doughnut chart with all subscriptions:
      1. In the General cost structure doughnut chart with all subscriptions, click the sector that represents the required subscription. The context menu is displayed.
      2. In the context menu, select Go to subscription analytics.
  3. Select the required resource category by doing any of the following:
    • Select the required resource category in the filter Additional filters > Category.
    • Select the required кesource category in the doughnut chart with a subscription:
      1. In the General cost structure doughnut chart with a subscription, click the sector that represents the required resource category. The context menu is displayed.
      2. In the context menu, select Go to resource category analytics.

  4. In the Granularity list, make sure Monthly is selected.

  5. In the Period list, select the period for the displayed data:

    • 3 billing periods — default.

    • 6 billing periods.

    • 12 billing periods.

    • Custom billing period — a period of up to 12 consequent billing periods limited by the billing days. To select a custom billing period:

      1. In the Period field, click the dates range. The calendar with the list of months is displayed.
      2. Click the first month of the required period. The selected month is highlighted.
      3. Click the last month of the required period. The months within the period are highlighted.
      4. In the calendar, click OK. In the Period field, the dates of the selected billing period are displayed as "First month YYYY — Last month YYYY".

    • Custom calendar period — a period of up to 12 consequent months. To select a custom calendar period:

      1. In the Period field, click the dates range. The calendar with the list of days is displayed.
      2. Click the first day of the required period. The selected day is highlighted.
      3. Click the last day of the required period. The period within the days is highlighted.
      4. In the calendar, click OK. In the Period field, the dates of the selected billing period are displayed.
  6. Wait until the data is loaded and displayed.

The cost structure for the selected resource category of a subscription is displayed in the following sections:

  • General cost structure — a doughnut chart where each segment shows the proportional value of costs per resource. The segments have labels with the component names and percentage values.

    To view the cost of a resource, hover the mouse pointer over the corresponding sector of the General cost structure chart. The tooltip with the name and cost with up to two decimal places is displayed.

    A resource may not be displayed in the diagram if its cost is less than 1% of the total cost.


    To filter the data by a resource, click the corresponding sector of the General cost structure chart. As a result:

      • The other sectors of the General cost structure chart become faded.
      • The Cost structure chart and the Summary table display the data for the selected resource only.

    To reset filtering, click the selected sector of the General cost structure chart one more time.

  • Cost Dynamics — the cost of the selected resource category of a subscription for the two previous billing periods and the percentage of the growth rate.

  • Monthly cost structure — a stacked bar chart that displays the dynamics of costs per resource for the selected period.

    To view the costs for a certain month, hover the mouse pointer over the corresponding column of the Monthly cost structure chart. The tooltip with the total cost and the costs per every resource with up to two decimal places is displayed.

    To exclude a resource from the Monthly cost structure chart, click its name in the chart legend. As a result, the Monthly cost structure chart is updated and does not display the excluded resource.

    To view the consumed data for only one resource in the Monthly cost structure chart, you can use filtering in the General cost structure chart (see above).

  • Summary — a table of costs per resource for the selected period.

    If the data in the table does not fit in width, use horizontal scrolling.

    The Summary table includes the following columns:

    • Name — the description of a resource.
    • <Month-year> — the costs for a resource per month.
    • Total — the total costs for a resource for the selected period.

    The sum of costs for a resource is displayed in the Total column, and the sum of costs of all resources for a month is displayed in the Total row. At the intersection of the Total row and column, the grand total of costs for the resource category for the selected period is displayed.

    The table supports the sorting of the rows by every column. By default, the Total column is used for descending sorting.

    The Name column also supports filtering by partial-match searching. To filter the table rows, start entering the search key in the Search by name field.

Filters

For analytics of a single pay-as-you-go subscription, you can use different filters. By default, the filter group is collapsed. To view and use the filters, click Additional filters and select the required options in the lists:

  • Category — see Analytics for a single resource category above.
  • Other filters — for details, see the corresponding service in Services. User documentation.

To reset a filter, click  in its field. To reset all filters, click Reset.

Filter templates

Additional filters are available depending on the service — for details, see Services. User documentation. You can save frequently used sets of additional filters as templates and then quickly apply them to a pay-as-you-go subscription.

To create a filter template:

  1. On a pay-as-you-go subscription analytics page, in the Additional filters group, set the additional filters you need.
  2. Click Save filter template. The New filter template window appears.
  3. In the Template name field, enter a name (up to 200 characters).
  4. Check the selected filters and their values.
  5. Click Save. The filter template will only be available to the current account user.

To apply a filter template to subscription analytics:

  1. On a pay-as-you-go subscription analytics page, in the Additional filters group, click Select filter template. A list of saved templates is displayed.
  2. Select the required template. If there are more than 10 templates in the list, you can search by part of its name.

Once you select a template, only those additional filters that match the selected subscription will be applied. Filters on the page remain editable. To reset all filters set by a template, click in its field.

If you need to change the set of filters in a template:

  1. Select the required filter template.
  2. Change additional filters. If you reset all additional filters, the template will also be reset and you cannot change it.
  3. Click Update template.

You can also view a list of all templates for the current user, and rename and delete a template. To do this:

  1. On a pay-as-you-go subscription analytics page, in the Additional filters group, click Pencil in the row with the required filter template. A window appears with a list of all templates for the current user.
  2. If you need to view filters and their values in a template, click in the row with the required template. A list is expanded with the names of the filters and the values ​​set for each of them.
  3. If you need to rename a filter template:
    1. In the row with the required template, click Pencil.
    2. Change the template name.
    3. Click .
  4. If you need to delete a filter template, click in the row with the required template.