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

report-12345,some_report_title,some_report_category,some_report_score

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

https://mysite.com/#/reports/report-12345,some_report_title,some_report_category,some_report_score

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

TIA!

Azulgrana

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.