About Eric_Lyons

Eric_Lyons · 08-16-2021

Hi all, A few customers have used the pie chart visualization and wanted to remove the measure label from the Tool Tip or hover state. There is no direct way to do this right now, but we can use a table calculation and a blank space character to hide...

Eric_Lyons · 07-07-2021

Knowledge DropLast tested: Jun 18, 2020 When we have data along a diagonal and we want to display it in a single column, we can use table calculations to do this! pivot_index(index(${users.count},max(row())-row()+1), row())This content is subject to ...

Eric_Lyons · 07-07-2021

Knowledge DropLast tested: Apr 27, 2020 import looker_sdkimport csvimport exceptions####Initialize API/SDK for more info go here: https://pypi.org/project/looker-sdk/from looker_sdk import methods31, modelssdk = looker_sdk.init31() # or init40() for ...

Eric_Lyons · 07-07-2021

Knowledge DropLast tested: Mar 19, 2020 If you have line items in a table with duplicate ids, but only wants the most recent items or highest items many times you will try to use a SQL subquery to SELECT MAX(DATE) for the given parameter, but you can...

Eric_Lyons · 07-07-2021

Knowledge DropLast tested: Sep 29, 2020 What abilities do admins possess that developers with maximum permissions not have?This is not an exhaustive list, but some examples of abilities Admins have that others do not:Managing users create/edit db con...

Eric_Lyons · 03-22-2022

Hey @stumpstumpstump,Can you run pip install looker_sdk --upgrade?I have seen a few colleagues run into this recently with older versions of the sdk. Thanks,Eric

Eric_Lyons · 03-17-2022

Can you try updating the import to remove 40 and then just reference models?

Eric_Lyons · 01-20-2022

Hi @Rahulkn,Filters always appear at the top of the dashboard, explore or look. If you are embedding the dashboard, you potentially could investigate the use of themes. You could use a text tile under the filters to label the “How much estimated savi...

Eric_Lyons · 01-18-2022

Hi @rohit_shoppertr, there is no way to directly connect a CSV on your local machine right now. You would have to put it in a database and connect the database to Looker or use the derived table union method as listed above. You can submit a request ...

Eric_Lyons · 01-17-2022

Hey @rohit_shoppertr,Do you mean load the csv as data in Looker rather than use a traditional database connection?You could use Google sheets and connect that through a BigQuery connection as noted here: https://help.looker.com/hc/en-us/articles/3600...

My Stats

dknezic's Bio

Badges Eric_Lyons Earned

Recent Activity

How to hide the field label on a pie chart or customize the measure label.

How to display the values along the diagonal here in one column

How to mass add users to a group from a CSV with Looker SDK!

Use Table Calculations to Get Most Recent Line Item When User Has Duplicate Rows (Non-subquery version)

Admin Permissions

Re: [LookerSDK] create_scheduled_plan: Models40 is not defined

Re: [LookerSDK] create_scheduled_plan: Models40 is not defined

Re: Creating a form for user input in Looker.

Re: How to load csv file present on developer local drive to Looker?

Re: How to load csv file present on developer local drive to Looker?