Staff
Since ‎01-05-2018
‎05-20-2023

My Stats

  • 68 Posts
  • 0 Solutions
  • 2 Likes given
  • 6 Likes received

Peggy_Beard's Bio

Badges Peggy_Beard Earned

View all badges

Recent Activity

Knowledge DropLast tested: May 21, 2019 Yes! You can get the query ID and then use run_query with result_format=sql https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/query#run_queryThis content is subject to limited support.
Knowledge DropLast tested: Jun 16, 2020Only if they are in different folders. If you try to create or rename a Look when there is already a Look in the folder with the same title you'll see an error message and you won't be able to save itThis conten...
Knowledge DropLast tested: Mar 5, 2021We can do it with merged results! Create the main query and then merge to the query for the "not in" part. The second explore's fields will be null when it's "not in" so you can use a yesno table calculation to f...
Knowledge DropLast tested: Aug 16, 2019 If your are asking how you can code an SQL WHERE clause that a user can conditionally apply, we can do this with a combination of a yesno parameter and an sql_always_where on the explore.The use case is that it...
Knowledge DropLast tested: Jan 14, 2021 The goal is to format the text, like with color or underline, and also have a link parameter with multiple drilldown options.This works:dimension: status {type: stringhtml: <P>{<!-- -->{ linked_value }}</P>;;link: {label: "te...