...
Page Properties | ||
---|---|---|
| ||
Introduction
As you know, XTM Cloud offers a vast range of reports that display certain particular data about projects. For (You can find out more information about the types of project-related report available in the XTM Cloud UI , read the following in this article: Costs & Metrics reports.)
You might come with a request to obtain a total number of It might be necessary to determine the total source word count for all projects created within a particular time range. The easiest way to obtain such value would be to do it this value is via the Assignment and words report.
This article presents provides a step-by-step procedure for obtaining a determining the total number of source words for the projects included in the scope.
...
Instructions
In XTM Cloud, go to select Projects → Project list → Advanced search.
...
In the Advanced Search section, select
All Projects
from the Project status dropdown, and . Then selectCustom range
from the Date created dropdown. In itthe date chooser, specify a the time range in which your the relevant projects have been created, and click select Apply. Finally, press select the Search button.
...
Next, switch to the Actions tab and . In the tab screen, select Reports → Costs and Metrics from the dropdown. Click Run.
...
In the popup, select the Assignment and Words report from the Report type dropdown. Also , make sure to ensure that you select the Search projects only checkbox; : this is especially important. Select
All
from the Status dropdown. Click Run. A report is generated and saved to an Excel file which is downloaded to your local computer.
...
Info |
---|
Alternatively, you can simply omit the actions in the Advanced search tab , and just specify the project range in the Date createdfield in the Costs and Metrics popup, from step 4. |
Open the generated Excel report.
The In the Total Word count (AD) column, the report displays a total source word count for each and every XTM Cloud project included in the report, in the Total Word count (AD) column.
...
To receive calculate the value of all total source words from the processed projects, you need to utilize use the Excel =SUM function. Simply provide Specify the first and last cell containing the word count for a particular project , and redirect the output to some vacant an empty cell nearby.
...
Note |
---|
IMPORTANT! Sometimes you might observe that in notice that the Total word count column value for some of the projects included in the report contains the Total word count column displays the null value (–) value. The possible root cause of the issue is that the projects in question have no assignments and/or only contain only Auto steps: If you wish to obtain words for such projects To determine the total word counts for projects like these as well, you can try using a different report that does not contain assignments; for example, . Example: Metrics, custom field included. However, this will require summing up the values from all TM match types thoughto be added together. |