Staff
Since ‎02-14-2020
‎05-20-2023

My Stats

  • 5 Posts
  • 0 Solutions
  • 0 Likes given
  • 18 Likes received

compressionai's Bio

Badges sam_pitcher Earned

View all badges

Recent Activity

It is common for date/time series tiles in a dashboard to be easily switched between date/week/month etc. This can be done with a parameter and liquid in the LookML. It is good to have a separate view file called parameters.view, maybe saved in a com<!-- --><!-- --><!-- --><!-- --><!-- --><!-- -->...
It’s common to want to switch between currencies in Looker. This is usually achieved by having your results/table in a base currency, for this example EURO. We can then have a currency conversion table that is joined in and you can convert the base c<!-- --><!-- --><!-- --><!-- --><!-- --><!-- -->...
A common way to analyse groups of data is to use the tiers parameter in LookML. This will group a dimension as needed for a given set of tiers. dimension: sale_price { type: number sql: ${TABLE}.sale_price ;; } dimension: sale_price_tiers { type: tie<!-- --><!-- --><!-- --><!-- --><!-- --><!-- --><!-- --><!-- --><!-- --><!-- --><!-- --><!-- -->...
Currently, the only was to get a custom welcome email is through the API. Here is a python script that uses the Python SDK that will return the setup urls for all the users that don’t have a Name, ie they haven’t set up there account. This solution s...