About PatKearns

PatKearns · 12-23-2020

Hi there,We are pulling data from the Looker API and typically pull:Models, then Explores.I noticed today, when trying to get the `sql_table_name` from the joins (LookmlModelExploreJoins), that all the `sql_table_name`s are ‘None’. Example output: Or...

PatKearns · 12-23-2020

Thanks for the reply @fabio1 !Ah okay, yeah not interested in PDT contents, just trying to scrape out sql_table_names for some data lineage work. I’ll check out the Python parser.

PatKearns · 08-26-2020

I believe what @mprogano was suggesting would work. Create a new dimension: dimension: department_filter { type: yesno sql: case when ${company_department} = 'Department Name' or ${product_owner} = 'Department Name' then true else false end;; } or pr...

PatKearns · 07-29-2020

Ah true, well, rather hacky, you can turn the color for yesterday’s data in the edit viz to white, so it disappears in the background. otherwise, you might be better off making 3 measures in lookML 1) todays value 2) yesterdays value 3) the delta

PatKearns · 07-24-2020

try pivoting on your date (and the day before) and using pivot_offset(). https://help.looker.com/hc/en-us/articles/360023624254-Using-offset-and-pivot-offset-in-Table-Calculations

PatKearns · 07-24-2020

the where syntax isn’t used in table calcs. You will probably need to do some nested if statement: if(${input_fields.field_label}=“Score H” and ${input_fields.field_value_number}=4, sum(${input_fields.field_value_number}), if(${input_fields.field_lab...

My Stats

SLOTGACOR168's Bio

Badges PatKearns Earned

Recent Activity

None value returned for sql_table_names from API

Re: None value returned for sql_table_names from API

Re: OR Conditions in Looker - a nightmare or am I just thinking wrong

Re: Delta Column in Looker Table Chart

Re: Delta Column in Looker Table Chart

Re: Calculation on one field with different values