About paola1

paola1 · 05-12-2022

Looker will not be updating this content, nor guarantees that everything is up-to-date. The ProblemWe want to compare the orders we have received this week, up to and including today, with the orders from previous weeks, up to and including the same ...

paola1 · 07-07-2021

Knowledge DropLast tested: Nov 16, 2017The history explore in System Activity includes both User-Defined and LookML dashboards. Because of this, when filtering on a dashboard id, the generated SQL will convert the ID to a VARCHAR.If you try to filter...

paola1 · 06-14-2021

Knowledge DropLast tested: Dec 24, 2019 An admin user will see a "Manage Access" option when viewing the folder. However, we can't manually specify which groups/users have access to this folder. This is defined in an SSO embed script.When an embed us...

paola1 · 06-14-2021

Knowledge DropLast tested: Apr 6, 2018 Only Admin users can see a user's API Client ID and Secret. Non-Admin users who have the see_users permission can see Client ID's but not secrets.If a non-admin user is given a Client ID and Secret for the API, ...

paola1 · 06-14-2021

Knowledge DropLast tested: Mar 20, 2018 You can send data to an S3 bucket using the Run Scheduled Plan Once endpoint.You'll need to replace the S3 bucket region, access_key_id, secret_access_key and query_id.{ "scheduled_plan_destination":[ { "format...

paola1 · 10-28-2020

What is your name? Paola Renteria What is your job title and industry? Product Analyst How long have you used Looker? 4.5 years Trailing or Leading commas in your SQL queries? LEADING! What’s the 1 Looker/Data related subject that you’d consider your...

paola1 · 06-11-2020

Hi @Shijitha! You can use custom filters to filter your results using OR logic. Hope this helps.

paola1 · 03-01-2019

No problem If you’d like to change what’s displayed in the tooltip, I recommend going through this discourse article which will walk you through how to use Liquid to change those values.

paola1 · 02-27-2019

Hey @Catherine_Huang, sure thing! We can create the percent of total field using Table Calculations. In my example above, I used the function ${users.count}/sum(${users.count}) Once you have that, you can hide the the Users Count column from the visu...

paola1 · 11-20-2017

Hey @Matthew_Darwin, you should also be able to use {{value}}. For example, html: <P> {{ value }} </P> ;; As you mentioned, rendered value is used when we want to apply Looker’s value formatting.

My Stats

it61's Bio

Badges paola1 Earned

Recent Activity

Week-to-Date (WTD) Comparison

Why does System Activity give the error data exception: invalid character value for cast`?

Is it possible to manage access for the Embed Groups space/folder?

Can non-admins find their API Client ID and Secret in Looker?

How can I send data to an S3 bucket via the API?

Re: ? Introductions Thread

Re: OR logic between filters in explore?

Re: Display % of totals on a stacked bar graph

Re: Display % of totals on a stacked bar graph

Re: Is there a way to change font size in "SINGLE VALUE" Visualizations