I have a table like thisCustomerproducttotalabca2abca3abcb4efga1efgb2lets say, I put a filter to show me anything where the total = 2so I get this table below (which is fine)Table 1Customerproducttotalabca2efgb2but if I have a single value visual on ...

I'm looking to create a case statement that will have two bucketsWhole numbers and numbers with values after decimal. 15,16,17.... would be the whole number bucket15.12, 16.0000000004, and 17.0003 would be in the other bucketRight now, I have the fol...

Is it possible to keep this field hidden, but have it shown on a customized tooltip?

when I look at week of the year in looker or even BQ, I see the following12/29/2021--- week 5212/31/2021 -- week 521/1/2022 ---week 52 1/2/2022-- week 521/3/2022-- week 1 is there a way to reset the week count ONCE the new year starts?

I have the following two statements dimension: test1 {type: numbersql: {% if ${event} = "ABC" and ${event1} = "ABC" %} then 1{% else %} 0{% endif %};;dimension: test2 {type: numbersql:{% if reservation_param._parameter_value == "123" and reservation_...