This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question
sarahuss
New Member
Since ‎03-24-2021
‎05-20-2023

My Stats

  • 8 Posts
  • 0 Solutions
  • 0 Likes given
  • 0 Likes received

sarahuss's Bio

Badges sarahuss Earned

View all badges

Recent Activity

How can I remove rows I don't want after applying a dynamic filter?

04-26-2021
I have created the following parameter to use as a dynamic filter: The user can select the best 3, 2 or 1st category that fits into a topic.### This parameter will allow a user to select a Top N ranking limit parameter: top_rank_limit { view_label: "...

Drilldown on derived dimension

03-30-2021
I am using Standard BQ SQL and trying to create a hierarchy on a dimension dimension: category { type: string sql: ${TABLE}.category ;; }that I split into three columns dimension: A_category { description: "Top level category" type: string sql:SPLIT(...

Extract substring based on delimiter

03-24-2021
HiI want to create three new columns from an existing dimension(called category) which has upto 3 keywords in it, with / in between them. EG/Hobbies & Leisure/Special Occasions/Holidays & Seasonal EventsHow can I do this in LookML? I tried the below:...