Is there a way to find the zoom level of the map through lookml code,
my sql looks like this
SELECT
CASE WHEN map_zoom<3 THEN bike_data.Country ELSE bike_data.State END AS bike_data_location,
COALESCE(SUM(bike_data.Order_Quantity)) AS bike_data_order_quantity
FROM `tgs-internal-saige-sandbox-001.retail_supply.Bike_Data` AS bike_data
GROUP BY bike_data_location
ORDER BY bike_data_location DESC
LIMIT 500 , without using drill down option when i zoom in map i want the map to show state wise orderquantity
the map_zoom throws an error here