convert a biq query sql to a looker dashboard/panel/look

[anilp]

HI 

I am new to looker ,

I have a simple sql

select count(*) from `acxm-amex-sandbox1a8e.infobase_data.emp` where Department_ID=1 and Employee_ID=5

Want to convert into a Dashoard/Look and  at runtime i should be able to pass the value to  Employee_id  dimension using drop down menu. 

thanks

[dsimeonova]

Hey @anilp !
What is your question? 
If this is possible? Yes, it is, using an Explore priorly set up on your LookML side.

Please share a little bit more of what is your current state or where you get stuck.
Kind regards,
Desi 😊