Hi Lucas,
Table grouping and aggregations will be available in R64, to release in a few weeks. You can read more about the capabilities at these pages https://support.seeq.com/kb/latest/cloud/what-s-new & https://support.seeq.com/kb/latest/cloud/tables-charts#id-(R64)Tables&Charts-GroupingandAggregating. I think this will fit your needs well to have a table of capsules with each failure, then group by the failure column. You can aggregate a count or sum all the capsule durations when you've grouped.
There's also an alternative Dashboard interface in Organizer in this upcoming release. While you cannot yet limit the table to top 5 (or N), tables inserted in Organizer Dashboards have a max height. This means you could configure it so that only 5 rows show and viewers can scroll to see the other rows (or not if not relevant). You can see that on the What's New page linked above or read more at https://support.seeq.com/kb/latest/cloud/inserting-content-dashboards
I do not expect transform() to help in the mean time. The transform() function is used to create a new signal or condition by applying a transformation to each element of an input series, such as a signal or condition. It operates on individual samples or capsules and does not provide aggregation capabilities like counting. My guess is it would be great to grab individual capsules but might be very complicated, if not possible, to group by properties and extract information that way.
