Set analysis where field = another field

[morenoju]

Hi guys,

I have a line chart with the following expression:

avg({<link_date={'1/5/2019'}>}speed)

Now I want that date to be picked by the user from a filter pane. I have another calendar that uses the field link_date_A, so I thought I'd be able to do:

avg({<link_date=link_date_A>}speed)

However, that does not draw any line.

Do you know if this is a syntax problem? I've tried different things without success.

Thanks

[dplr-rn]

I am assuming the 2 dates are in different tables.
if so try something like this

avg({<KeyIDColumn={"=link_date=link_date_A"}>}speed)

[morenoju]

Thanks for your response. However, the line is being drawn without me selecting anything from the link_date_A filter pane. And when I do select different dates, the line is not changing. That makes me think it's not doing the job.
Do you have any other idea?
Thanks!

[sunny_talwar · Accepted solution]

May be this

avg({<link_date = p(link_date_A)>}speed)

[dplr-rn]

You mean the date link_date_A is being picked by a filter?
if so try 2 options
1- create a variable which will format picks appropriately and use it in your set analysis.
2 - p(link_date_A) method

[morenoju]

Thank you, guys. I'm going to use the p(link_date_A) .