About JMJ1

JMJ1 · 10-15-2021

Is it possible to include constantvalues (defined in manifest.lkml) in text values?

JMJ1 · 03-08-2021

Hi,I would like to create or define a environment variable/s to add in a query , this variables should be get from a table. I mean:variable last_day_dt_Madrid= (select max(day_dt) from table_raw where city=’Madrid’ )variable last_day_dt_Barcelona=(se...

JMJ1 · 03-02-2021

I would like to add html code in the title of a Look.Is this possible? 

JMJ1 · 03-01-2021

Hi everyone,I have built a dashboard with a month filter (date time format).The info in this dashboard read from a table that is loaded and updated periodically with new months. I would like that default value of the month filter be always the last m...

JMJ1 · 05-23-2023

¿El valor rut es único en cada fuente de datos? es decir no se repite? Debería ser así si se usa como campo de cruce.

JMJ1 · 12-28-2022

Hi,There are different options, one of them is to create a parking_group dimension:

JMJ1 · 01-19-2022

Hi,Another option is to define a dimension (view) with the possible 10 numeric values, and add a full outer join in the explore.explore: my_table { join: user { sql_on: ${my_table.nps} = ${dim_nps.nps} ;; type: full_outer }}Best regards

JMJ1 · 01-18-2022

Hola Paco,If the default value stored in the DB as a single value of a table, you should to define the table as a lookml view and include it in the model as a cross join against the fact table , for example : join: table_x{ type: cross sql_on: 1 = 1 ...

JMJ1 · 12-07-2021

You could to define a explore of the main view and the join with the another view. After that you could define a dimension type yesno. For example:in the model:explore: view_A { join: view_B{ relationship: many_to_one sql_on: ${view_A.????} = ${view_...

My Stats

JMJ1's Bio

Badges JMJ1 Earned

Recent Activity

Is it possible to include constant values in text tiles?

Variable to use in a Query

HTML code in the title of a Look

Dashboard, set last date as default in date filter?

Re: problema con datos combinados

Re: Concatenete values

Re: Elegant solution for Missing Values in numeric dimensions?

Re: Use default value of a field

Re: How to compare values in two columns in custom filters