OK, let’s recap the situation. Left query seems ok, it properly populates table panel. Data link is set on the state field and when you click it, variable us_state is properly set (btw, unhide it for now, you’ll hide it later). Properly in a sense, that it contains clicked state name, like Alabama, without leading or trailing spaces.
And all this is confirmed to be good it seem the remaining issue is the right panel query, which does seem to pick up the variable properly, but somehow doesn’t spit out the expected results.
Does this describe the situation?
Left Panel - Mouse over - the state value changes…but for our test - I make sure to click - other than showing the ‘state_nm’ = ‘Alabama’ or something - I really don’t know if the actual variable that I created and - ‘State_nm’ is getting the value from the ‘state_nm’ capture value
Right Panel - If I just give the actual value ‘Alaska’ - I get the results
It’s not getting the value. The variable, that is. In Data Link add var- in front of the variable name, so it will read like origId=1&var-state_nm=${__value.text}. And unhide the variable, Variables / state_nm / Hide / (blank).
So now when you click the link, variable should get populated and you should be able to see it on the top part of the dashboard. Can you screenshot it?
OK, at least you’re good on that part. Great. Let’s investigate the right panel query. Can you show what query inspector says? I believe we already tried to punch in Alabama as query filter instead of variable, right? And it worked?
