Lucas J

Thanks for the information John. This is helpful context for my use case. Do you know which upcoming Seeq version will contain the pivot table functionality? As far as the current options you presented, here are my thoughts: I have used the Histogram tool approach and it does allow me to show relative bucket size by count/duration. Like you mentioned, it does not allow for sorting into a pareto view. Being able to sort the histogram would be very close to what I am trying to accomplish. One issue I ran into is the alarm messages are truncated on the histogram x-axis. Unfortunately, I have a large amount of alarms and that list is dynamically adjusted according to various business scenarios. I think this is my best potential approach. I thought I would ask before pursuing a Seeq Data Lab solution. One unrelated question: could the transform() Formula tool be a potential approach. I notice in its documentation that it mentions, "Get the first capsule of $condition in each week. If there are weeks that don't have any capsules in them, the resulting condition will be empty during those weeks." Thanks again for your help!

I am trying to figure out how to create a table that shows the Top 5 machine alarms by count for the last X hours and another table that shows the Top 5 machine alarms by duration for the last X hours. Ideally the table would look similar to what I have sketched out below. I have a continuous discrete signal that is the active alarm on the equipment. So I can create a Condition with Properties that has the alarm description as a capsule property. I now need to count the alarm capsules by description and then rank them from highest to lowest. Any help/suggestions on approach would be appreciated.