About ryangifford

ryangifford · 05-18-2022

I’m using the Looker API Get Query to change the underlying view of some dashboards (I’m trying to simplify and automate what I’ve been doing in the content validator). All of the field names include the view name like “table1.customer_name”. Is ther...

ryangifford · 04-08-2022

I have some data that looks like this:Group Name Price70450 Facility $70070450 Professional $6870450 Misc. $7880000 Facility $85080000 Professional $7080000 Misc. $109I want to create a dimension or measure that will sum the price of rows where “Name...

ryangifford · 03-18-2022

I’m using the Python SDK with 4.0 API to give one group permission to a newly created folder. By default, folders inherit the access permissions of the parent folder and want to use the SDK to make this folder not inherit these permissions. This is t...

ryangifford · 05-10-2022

You could do this with table calcs and just hide some rows from the visualization. It might be easier with a group statement in the Lookml but here’s the idea:row_id_calcif(match(${ID},${ID})=offset(match(${ID},${ID}),-1) , 1+row()-match(${ID},${ID})...

ryangifford · 04-12-2022

Thank you, that makes sense! I’ll give this a go.

ryangifford · 04-12-2022

@IanT Thanks for the reply. This works only if I remove the “name” dimension. Is there a way to keep all the dimensions and rows there and still aggregate select rows?

ryangifford · 03-25-2022

@lantrann This worked perfectly. Thanks for the quick response!

ryangifford · 03-07-2022

Hi, you can do this by appending this to the url of your dashboard: _theme={"show_title":false}See more here: https://docs.looker.com/admin-options/settings/themes#using_the__theme_url_argument_to_apply_individual_dashboard_theme_elements

My Stats

ryangifford's Bio

Badges ryangifford Earned

Recent Activity

How to change fully scoped field names in Looker API query body

How to sum certain rows if dimension contains certain text? (Not in table calcs)

API 4.0 Update Content Metadata "inherits" : "false"

Re: How to return column A value based on largest column B value

Re: How to sum certain rows if dimension contains certain text? (Not in table calcs)

Re: How to sum certain rows if dimension contains certain text? (Not in table calcs)

Re: API 4.0 Update Content Metadata "inherits" : "false"

Re: Hiding an embedded dashboard title