User Manual

10.29.2024

MANUAL

Manage Table: Aggregation

## Overview Set the "[Column](/en/manual/table-management-column)" to be displayed in the "[Aggregation](/en/manual/table-record-aggregation)" field at the top of the "[Screen Index](/en/manual/table-grid)". Using "[Class Column](/en/manual/table-management-class)" enables "Grouping" by classification for aggregation purposes. ## Limitations 1. Only "「Work Volume Column」", "[Remaining Work Volume Column](/en/manual/table-management-remaining-work-value)", and "[Numeric Value Column](/en/manual/table-management-num)" can be used for "Total" and "Average" aggregation. 1. Only "[Status Column](/en/manual/table-management-status)", "[Manager Column](/en/manual/table-management-manager)", "[Owner Column](/en/manual/table-management-owner)", "[Class Column](/en/manual/table-management-class)", and 「Check Column」" can be used for "[Column](/en/manual/table-management-column)" in "Grouping". 1. "Grouping" by "[Class Column](/en/manual/table-management-class)" that have "[Multiple Selection](/en/manual/table-management-multiple-selections)" enabled cannot be performed. ## Prerequisites 1. "Site Administration Permission" is required to configure settings. ## Operation Image ![image](https://pleasanter.org/binaries/6ea779b3da054dcb9de9aabfa2bb30bc) With the relevant table open, click "Manage" > "[Manage Table](/en/manual/table-management)" from the navigation menu. --- ![image](https://pleasanter.org/binaries/ebde9a76fa8e48f2a6f0c67029ba37eb) "[Aggregation](/en/manual/table-record-aggregation)" is performed by "Grouping" using the "Added [Column](/en/manual/table-management-column)" to "Count", "Total", and "Average". Selecting "No Classification" performs "[Aggregation](/en/manual/table-record-aggregation)" without "Grouping". ![image](https://pleasanter.org/binaries/a5ea80ee93564d0095afec4a312411c6) ### 【Default State】 ![image](https://pleasanter.org/binaries/389e86bfc72f4c9091000c130ae4ede2) ### 【Enable Owner and Aggregate the Count by Owner】 ![image](https://pleasanter.org/binaries/07289b7b3fd74fff8150e3f3688e19e0) ### 【Aggregation Results on the Screen Index】 ![image](https://pleasanter.org/binaries/8fc5f16e9dff4d30af72e24f83c1b199) ### 【Check Column】 If "Grouping" by "「Check Column」", "[Aggregation](/en/manual/table-record-aggregation)" is performed for "Unchecked" and "Checked" column. (Left side represents "Unchecked," and right side represents "Checked.") ![image](https://pleasanter.org/binaries/2f524981a98347d5b988b5f4a06f38d8) ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/table-grid">Table Function: Record Screen Index</a><span>10.02.2024 up</span></li> <li><a href="/en/manual/table-record-aggregation">Table Function: Record Aggregation</a><span>10.07.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management">Manage Table</a><span>10.02.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-column">Manage Table: Column</a><span>10.07.2024 up</span></li> <li><a href="/en/manual/table-management-remaining-work-value">Manage Table: Column: Remaining Work Volume</a><span>10.11.2024 up</span></li> <li><a href="/en/manual/table-management-status">Manage Table: Column: Status</a><span>10.02.2024 up</span></li> <li><a href="/en/manual/table-management-manager">Manage Table: Column: Manager</a><span>10.02.2024 up</span></li> <li><a href="/en/manual/table-management-owner">Manage Table: Column: Owner</a><span>10.11.2024 up</span></li> <li><a href="/en/manual/table-management-class">Table Management: Item: Classification</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-management-num">Manage Table: Column: Numerical Value</a><span>10.02.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-multiple-selections">Manage Table: Editor: Column Advanced Settings: Multiple Selection</a><span>10.02.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.