We are using looker through Chrome River (Emburse Analytics) and trying to combine 3 fields into one. We have ...
Hi Community!What are the differences between measures leveraging Looker Filter Expressions and When Case Stat...
Please help. For context, 1 user can have multiple generations of a product. Generation 1Generation 2Generatio...
Please help. For context, 1 user can have multiple generations of a product. Generation 1Generation 2Generatio...
Does anyone know how can i get this ?I want to create rolling 3 month count of a measure .So basically if i wa...
Hi,I need to use YesNo Dimension in Case When statement and check if it’s not equals to “Yes”, then put some v...
I have a dimension (StageName) with 10 or so possible values. There are a few different combinations in which ...
If i want to return not a string but a metric value, can that be done using case in Looker?
I am trying to create a measure conditionally based on a dimension.My dimensions:dimension_group: date { hidde...
I am adding CASE statements to my filter in my views. I basically want that if the user types `Harry` the filt...
Hello, I am hoping someone can give advice. I am looking to bucket orders.My goal is to create two custom dime...
dimension: example { type: string sql: CASE WHEN ${order_amount} > 100 THEN 'Large' WHEN ${order_amount} > 50 ...