Arcade pop-up using Intersect and interrogating data
If you can get the relevant samples returned as its own FeatureSet, you can do more with it. However, a single expression is only going to output one thing. You can get the different values into a big output string, but you can't color code them using HTML unless you're willing to write a separate expression for every single potential line in the output string, and unless you know the upper limit of potential values per county, this doesn't seem easy or worthwhile.
Still, getting it into a big string is possible:
// Get samples layer
var samples = FeatureSetByName($map, 'samples')
// Clicked county name
var county = $feature.county_name
// Filter samples by county
var county_samples = Filter(samples, "county_name = @county")
// Group filtered samples by year, count per category
var grouped_a = GroupBy(
county_samples,
['surveyed', 'a'],
{name: 'count_a', expression: 'a', statistic: 'COUNT'}
)
var grouped_b = GroupBy(
county_samples,
['surveyed', 'b'],
{name: 'count_b', expression: 'b', statistic: 'COUNT'}
)
We group a and b separately so that we get the true count of each, rather than the count of unique a/b combinations.
Using these grouped FeatureSets, we can then populate our string using a few loops.
var years = Distinct(count_samples, 'surveyed')
var out_str = ''
for(var y in years){
var the_year = y['surveyed']
out_str += `${the_year}, a: `
var filt_a = Filter(grouped_a, 'surveyed = @the_year')
for(var a in filt_a){
if(a['count'] > 0){
out_str += `${a['count']} ${a['a']}, `
}
}
out_str += 'b: '
var filt_b = Filter(grouped_b, 'surveyed = @the_year')
for(var b in filt_b){
if(b['count'] > 0){
out_str += `${b['count']} ${b['b']}, `
}
}
out_str += '\n'
}
return out_str
And after all that, we get this (I used static input data instead of a real FeatureSet, my output will likely differ form yours):
2005, a: 1 High, b: 1 Low,
2006, a: 1 High, 1 Low, b: 1 Low, 1 Medium,
2007, a: 1 Low, b: 1 High,
2008, a: 2 Medium, b: 1 Low, 1 Medium,
There's the nagging comma at the end of each line. You could deal with this by pushing the bits of text into a series of arrays and using Concatenate, but that's probably overly complicating things.
As a bit of an aside, I think what you're doing here is a bit much for a popup. A Dashboard could present this same data with nice formatting in a series of indicators and charts, and would probably be easier to do.
