URL templating - Is it possible to split the output of event.values?

Hi there!

I'm working on a "Table row click" drill down for one of my Lens tables, my goal is to have a drill down off a hidden field (report Id) to make it easier for the users.

the event.values variable return an array similar to the one below


I tried doing something like

https://mysite.com/#/reports/{{{split event.values "," 0}}

with the idea of extracting the just the first element "report-12345" but that didn't work. What I get in return is just the array with all the elements


Any ideas on how to use split to extract a given element?



this did the trick for me

{{lookup (split event.values ",") 0}}

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.