I'm trying to publish a dashboard for several companies by scheduling an email and  giving them a URL for the dashboard per company. I have one dashboard with a user filter by company drop down on the whole dashboard.

The dashboard consists of reports from two different tables. The filter when manually selected works for all the reports. I have created a query table that joins the two tables with the intention using it for generating the URL but it is not listed in the column(table list) see attached pic. I cannot generate the URL per company. Is there a step I'm missing?

Alternatively I can pass the company value on the user filter in the URL but I also don't know how to do that(Attached pic) 

Please help.