About Ginto

Ginto · 04-19-2020

We have a scheduled legacy report for conversion to Looker that requires display of required and optional fields. Instead of creating multiple looks for each optional fields, is there a way to create just one look and dynamically choose which fields ...

Ginto · 04-15-2020

Hi I’m using a derived table view with this conditional clause below. How do you translate this from snowflake tol lookml? Please advise where MSG_TIMESTAMP >= ‘&RPT_DAY_SF’::timestamp - interval ‘&DAYS_BACK days’ + interval ‘&CUTOFF_HOUR hours’ AND ...

Ginto · 04-20-2020

Hello @menashe For our use case it is just a simple tabular report that we schedule daily or weekly for each of our customers to receive via email or SFTP. Our customers will have no access to the schedules. We are the ones who create the schedule fo...

Ginto · 04-18-2020

@moebe Please see Cyril’s response to address my problem. But thank you for your response. Your doc link will be something I can use going forward for my learning curve.

Ginto · 04-18-2020

@Cyril_MTL_Analy , This is perfect! It will work the way we want it for our legacy reports which we are migrating from old reporting tool to Looker using snowflake. So basically we are still learning. Thank you!

Ginto · 04-17-2020

Hi Cyril, I was able to code those variable parameters into the above WHERE clause in my derived table view (Snowflake sql) as: WHERE MSG_TIMESTAMP >= current_date::timestamp - interval ’ {% parameter days_back %} days’ + interval ’ {% parameter cuto...

My Stats

Ginto's Bio

Badges Ginto Earned

Recent Activity

How can you dynamically hide fields from table visualization depending on customer request.

date dimension comparison with date range

Re: How can you dynamically hide fields from table visualization depending on customer request.

Re: date dimension comparison with date range

Re: date dimension comparison with date range

Re: date dimension comparison with date range