About JVFrancis

JVFrancis

I am trying to create/update table/view inside a SQL based derived_table in LookML. Is that possible? I keep getting an error which prevents the creation of the PDT in Looker but the query statements run fine in BigQuery and the table/view gets creat...

JVFrancis

I am trying to create a dynamic filter to use in a dashboard. Ideally when the user selects a value from the Filter Selector filter the values in the Dynamic Filter filter would change accordingly. For example, if the value "Age" is selected from the...

JVFrancis · 05-01-2024

I am using a dimension as a filter in a dashboard. I am also using the same dimension as a visual in the same dashboard. Below is the LookML for the dimension I have created,dimension: DataLastUpdatedAt {label: "Data Last Updated At"type: stringsql: ...

JVFrancis · 04-16-2024

I am trying to add fields (more than one) dynamically from a filter (which has a list of fields defined as a measure/dimension in the LookML) to an existing dashboard visual (table). So when I select a field or more than one field from the filter the...

JVFrancis · 02-10-2021

Hi! I recently implemented Pop Analysis Method 4 (Compare Multiple Templated Periods) in an explore. It works fine except for the Period dimension. When I select the Number of Periods parameter as 2 I should be getting just This Year and Last Year as...

JVFrancis

Thanks! Have a good day!

JVFrancis

I got it working by using the below code at the end of my derived_table LookML for creating the topparenttable view as given in the sql-create documentationcreate or replace table ${SQL_TABLE_NAME} as (My final select query); select * from ${SQL_TABL...

JVFrancis

I tried using sql_create instead of sql in the LookML but I got the "Not found: Table us-ezl-dl-ingest-919726cd:looker_scratch.LR_8KE3O1724769551198_topparenttable was not found in location us-east4" error in the explore. topparenttable is the LookML...

JVFrancis

I am using the regular derived table syntax

JVFrancis

@marcwo Sure! I am trying to run a sequence of create/update queries to be used as a LookML view. The temp table "Parent" gets created when I run these queries in BigQuery but I get the error "message": "configuration.query.destinationTable cannot be...

My Stats

Dmitri_S's Bio

Badges JVFrancis Earned

Recent Activity

Creating and updating a temporary table in LookML

Dynamic Filter in LookML

Value in filter not getting updated in dashboard

Select fields dynamically from a filter to use in a dashboard visual

Pop Analysis Method 4 (Compare Multiple Templated Periods) - Period Issue

Re: Creating and updating a temporary table in LookML

Re: Creating and updating a temporary table in LookML

Re: Creating and updating a temporary table in LookML

Re: Creating and updating a temporary table in LookML

Re: Creating and updating a temporary table in LookML