Nested Variables for elasticsearch

I would like to have 2 variables in my dashboard Category and URL and nest them, ie:. If Category = AJAX I only want the URL tab to show URL’s that have a category of AJAX not all URL’s. My first variable Category looks like this {“find”: “terms”, “field”: “category”} my second should be something like {“find”: “terms”, “field”: “url.keyword” if $Category = AJAX} but I’m not sure how to code that … Any suggestions welcome

Sorry fixed this one myself when i thought about it … You just do this in case anyone else needs an example.

Variable Definition
Category {“find”: “terms”, “field”: “category”}

URL {“find”: “terms”, “field”: “url.keyword”, “query”: “$Category”}

1 Like

Thanks a lot! U just saved my day. :smiling_face_with_three_hearts: