Imagine you want to list the list of assets and the number of risks associated with them, today you can list the risks associated with them but not the “counter”.
go to asset identification module
edit filter, add the risk name field and make sure is shown as column
but say you want to get the counter of risks , not the list of risks (as labels as we have now) … we need on the filters an option that allows us to show items as counter nor just names.
So we need to let users define for every multiple select filter (MS) on any filter on any section on the show in column a dropdown that lets them choose WHAT they want to see on the column, options are:
Item Name/Value (basically show the same we show now)
Counter
When the filter is shown with the counter , the column header you have the “Count” appended to the original name … “Account Review Pull (Count)” instead of just “Account Review Pull”. Also the number shown must be a link to the items !!
How many risks has an asset associated? Pivot tables in use ! … also a dynamic status that triggers when the related count of risks for an asset is zero.