Forum Discussion

Excel's avatar
Excel
Iron Contributor
Jul 26, 2022
Solved

Query related to Excel

Hello Everyone.    i want to filter how many incident for CPU and memory related alerts, need to filter server name?   Please help..   Here is a attached file...    
  • HansVogelaar's avatar
    Jul 26, 2022

    Excel 

    Please give your discussions a more relevant subject. ALL topics in this forum are related to Excel.

     

    See the attached version. I added two helper columns with formulas to extract the host and the type of alert.

    You can use these for filtering, and/or for a pivot table.

Resources