How to get Looker to accurately parse comma separated values
I am totally stumped.I am using a Sheet as my data source for a chart in Looker.This Sheet is receiving Form r...
Forum Posts
Calculate Standard Deviation and Percentiles by Country
How can I get a table where I can see the country code, the count of accounts created and the standard deviati...
Add milliseconds to DateTime within Explore Custom Dimension
I’m trying to do something like this within an Explore Custom Dimension:add_milliseconds( ${Hits.HitTime} ,${S...
Lookerstudio barchart filtered by columns
Hi everybody,I am facing some issues trying to create a barchart on Lookerstudio.I have a GSheets dataset wher...
Field Added to Data Source - Formula Only Look Between Specific Dates
Hello All, a conversion source in Google Ads changed and I wanted to only pull a formula rule between a specif...
Custom field
Hi All,I need to calculate the performance to a filed on my website.I have these GA4 events: Total Users and S...
Concatenete values
Hi,I would like to know how can I create a new field which will concatenete x values (area code) into one stri...
How do you group a list and count each user on the list from 2 separate columns?
HelloJust as an FYI, I cannot use LookML. I am forced to stick with custom filters/dimensions/measures/table c...
Adding in the Custom Expression field
Hi,As you can see in the image, I’m trying to make a column that shows the value of 3 other columns combined. ...
[Custom Field] Extracting key pay from a field
Hello,I am trying to create a custom field that extract data from a field (assuming the field is called “my_in...
Looker creating new group custom dimesion group when i try edit current
Hello,I’m trying edit a old dimension custom field group by Sellers, but when i select Edit, looker load a new...
Using custom dimension to generate a series from scratch
Making a custom dimension from scratch using expression = `now()` creates a new table with 1 column and 1 row ...
String to date
Is it possible create a customer dimension in looker for date using string data? Does it need to be in a parti...
Custom measure, does not contain "X" except before a cutoff number "X"
Hello, I am hoping someone can help me with this question. I want to create two custom measures and/or table c...
Custom Measure for finding value for today and yesterday
I am needing to show the number for today and yesterday for a specific dimension. I have a measure already for...
create simple case statement in custom dimension or table calculation.
Why is it so hard to write a simple case statement in custom dimension or table calculation. Can some one help...
Exclude a measure from being filtered
I have a table calculation with a query like below:count_distinct user_id / total_number_of_usersBoth are basi...
Pivot with values in different columns
Hey folks, I’m still fairly new to Looker and I’m trying to format some data in a way that I can easily produc...