@str8edgedave I just came across your post as I was revisiting this same question. Unfortunately I don’t believe that that (nested) template variable evaluation happens on a row-by-row basis currently, and that’s what causes the issue you observe. There is a broader discussion of this at Having trouble getting nested variables to work together.
In your case, my take is the following:
- Your
$targeturltemplate variable has the same 8 URL values on both rows (7 internal + 1 external). Note that the querySHOW TAG VALUES FROM "ping" WITH KEY = "url" WHERE "realm" =~ /^$realm$/is evaluated on a dashboard level, and not on a row level. This explains why you see the 8 entries on each row. - When you query for
realmANDurl, you will get data for the 7 URLs in the internal realm shown on the internal row, and for the 1 URL in the external realm on the external row. By this token, for example you won’t get any data forrealm='internal' AND url='google.com'- because your database has no entires there. This will probably be apparent if you look at the queries being executed (via the inspector).
I’m conscious that a response ~1 year after your post may not be particularly helpful, but figured I’d share for the benefit of anyone else just stumbling upon this.