June 4, 2012
Calculated Fields Conundrum - List Item or Text for Output Type
When you first start exploring custom calculated fields in TestTrack, you might find yourself wondering what the differences are between the text and list item output types. Which type should you use since the end result is a text value in both cases?Email sign up
While both types of calculated fields produce text as their output, text fields are more flexible in terms of the possible values the field can have—any combination of legal characters is allowed (up to 255 characters). List item fields are limited to one of the values in an associated list of text values.
Does this mean that it's better to use text fields?
Not necessarily. Which output type is better for you generally depends on the type of reporting, filtering, and sorting you want to do with your data.
|[caption id="attachment_11580" align="aligncenter" width="256" caption="Calculated field with text output"][/caption]||[caption id="attachment_11581" align="aligncenter" width="256" caption="Calculated field with list item output"][/caption]|
ReportsReports that group and count data, like distribution reports and Live Charts, work with predefined lists of values. If you want to use these types of reports with your custom calculated field then you must use the list item output type.
Table: Field output types supported for different TestTrack report types[caption id="attachment_11586" align="aligncenter" width="420" caption="Risk level is a calculated custom field using list item output"][/caption]