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
Custom Dimension to Count Business Days
Hi, is it possible to create a custom dimension to only count business days between two dates? The custom dime...
How can I create a dimension that captures if all entries in a column of are completed?
Hi! The title is a bit confusing, so I will put an example here:I have a survey that gets sent out to Users. I...
Is it possible to insert a created user attribute into a look as dimension column?
Hi,I know you can create user attributes in the admin settings. In this case, I’m doing something simple like ...
How to create a calculated field which is customized based on filter selection?
Hi there, I have created a custom drop-down list (using CASE WHEN formula) which groups campaigns together bas...
Display months as words instead of numbers
I am currently trying to display Months in a word format instead of a number format for a tile. Above is what ...
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...
Hierarchial filters to load looks
Hello Commnunity,I am looking to create something similar to hierarchial slicer on powerbi. In my case i have ...
Calculate percentil 95 over a dimension and group by day
Hello everyone!I would like to know if is it possible to calculate a percentil over a dimension and group by d...
Custom Dimension: Changing font color based with function based on result
Hello to all,Writing you with a simplified version of my issue, as I’m looking for a coded way to change font ...
count table calculation
Hi.how to count table calculation (MonthDiff) ?..MonthDiff is datediff(maxtrxbooking, Now())i want to show lik...
Data Visualization: 3 dimension (2 categories) and 1 date variable.
Hello I am curious if anyone knows of a good way to visualize a measure over time with two categorical dimensi...
Possible to create a link/url custom dimension?
Hello!Is it possible to create custom dimensions that are formatted as links? For example, taking an Order ID ...
Converting dimension to a measure
Hi,I’m struggling with creating some basic graphs in Looker. Although I’ve already setup some dashboard, this ...
Inconsistencies between Time and Duration dimension group types?
Why do “duration” dimension groups prefix a “Duration “ to the dimension group name, whereas “time” dimension ...
Measure not grouping by pivoted dimension properly
Getting some unexpected results when I attempt to pivot a measure by a dimension. I would like the pivoted mea...
Create custom dimension from a substring of another dimension's
Hello – I’m looking to create a custom dimension based on the substring of another dimension. I’m ingesting th...