![]() ![]() In the example below, a rollup includes a condition to calculate the average days old for all bugs with critical priority and a status of being blocked. You can also add multiple conditions for each rollup, lookup, and count field by creating a conditional group. The number of high priority bugs here can help determine which features need the most attention. In our example, you could set the filter to only count bugs with priorities of either “Critical” and “High” from the other table (Bugs & Issues). The conditions you can apply here work the same as view filtering where you select a field, an operator, and a comparison value. To configure, check the “Only include records which match certain conditions” toggle. If you wanted to only see the number of high priority bugs for a feature, you could configure a count field to be filtered to just the “Critical” and “High” priority bugs. For example, a “Bugs & Issues” table may be linked to a “Features” table to show all the bugs related to each feature. ![]() Once you have a lookup, count, or rollup in your table, you can configure it to only show a subset of related information. Fields that require linked record fields (lookup, count, and rollup).If you do not already have one of these fields created, see the following to first connect the tables and then to create a field that pulls in or calculates additional values from one table to another. How it worksĪpplying conditions to an existing lookup, rollup, or count field means that you already have two tables connected by a linked record field. This is ideal for when you only want to show a subset of related records such as showing only pending tasks for a project or only employees with birthdays this month. By default, these fields will pull in all the linked records from the other table, but you can choose to apply conditions to filter on these fields to limit what is included. Lookup, rollup, and count fields in a table use linked record fields to pull in values from one table to another. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |