–UPDATE-- I ended up just using existing automatic groups to get this to work.
I’m trying to create a custom web report which returns a row for each unique value of one analysis, and then multiple columns for additional counts based on other analysis results for each of those unique values in column 1. The end table I’m hoping for would look something like:
“Analysis 1 result” | total computers with Analysis 1 result | total computers with analysis 2 or 3 result | total computers WITHOUT analysis 2 or 3 result
“Some result” | 14 | 10 | 4
"Another result" | 20 | 9 | 11
Initially I was working with the following relevance, but can’t find a way to make it return multiple counts for each ‘analysis 1 result’
( it, (multiplicity of it as string) ) of unique values of values of ( results (it, bes properties "Analysis 1 property" ) ) of ( bes computers whose( (exists values whose(it contains "string 1) of ( results (it, bes properties "Analysis 2" ) ) of it) ) ; bes computers whose( (exists values whose(it contains "string 2") of ( results (it, bes properties "Analysis 3 ) ) of it)))