Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 2 Current »

Introduction

As you know, XTM Cloud offers a vast range of reports that display certain data about projects. For more information about types of project-related report available in the XTM Cloud UI, read the following article: Costs & Metrics reports.

You might come with a request to obtain a total number of source word count for all projects created within a particular time range. The easiest way to obtain such value would be to do it via the Assignment and words report.

This article presents a step-by-step procedure for obtaining a total number of source words for the projects included in the scope.

Instructions

  1. In XTM Cloud, go to Projects → Project list → Advanced search.

  1. In the Advanced Search section, select All Projects from the Project status dropdown, and select Custom range from the Date created dropdown. In it, specify a time range in which your projects have been created, and click Apply. Finally, press Search.

  1. Next, switch to the Actions tab and select Reports → Costs and Metrics from the dropdown. Click Run.

  1. In the popup, select the Assignment and Words report from the Report type dropdown. Also, make sure to select the Search projects only checkbox; this is especially important. Select All from the Status dropdown. Click Run.

Alternatively, you can omit the Advanced search tab, and just specify the project range in the Date created field in the Costs and Metrics popup, from step 4.

  1. Open the generated Excel report.

  2. The report displays a total source word count for each and every XTM project included in the report, in the Total Word count (AD) column.

2024-10-23 14_13_24-Assignment and words 2024_10_23_10_54_26_101.xlsx - tylko do odczytu - Excel.png

To receive the value of all source words from the processed projects, you need to utilize the Excel =SUM function. Simply provide the first and last cell containing the word count for a particular project, and redirect the output to some vacant cell.

2024-10-23 13_33_00-Assignment and words 2024_10_23_10_54_26_101.xlsx - tylko do odczytu - Excel.png

IMPORTANT!

Sometimes you might observe that in some of the projects included in the report the Total word count column displays the null (–) value.

2024-10-23 14_23_11-Assignment and words 2024_06_13_09_41_09_269.xlsx - Excel.png

The possible root cause of the issue is that the projects in question have no assignments and/or contain only Auto steps:

If you wish to obtain words for such projects as well, you can try a different report that does not contain assignments; for example, Metrics, custom field included. However, this will require summing up values from all TM match types though.

Untitled2.png

  • No labels