thank you very much ... View more

I apologize. I don't know how to transform the first photo into the last. I was given the last photo as an example and I am attempting to turn the first photo into the last, that is the reason why I am here. I was hoping that someone would know what it would take to transform the first photo into the last. I do not have the code to do that.   here is the code to the first solution   | makeresults | eval systemName="CE", ID="12345-MA-12345", severity="Critical", vulnCount="10" | append     [| makeresults     | eval systemName="CE", ID="12345-MA-12345", severity="High", vulnCount="5"] | append     [| makeresults     | eval systemName="3E", ID="23456-MA-23456", severity="High", vulnCount="10"] ... View more

the code for the transition from the first to the last is what I am trying to accomplish. Displaying systemName, ID total of High and Critical by systemName. I attempted to use eval split function and mvindex but couldn't quite figure it out.      ... View more

I would like to use the data in the first photo (dashboard ) to create the second photo (dashboard).  ... View more