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.
Hi @shakermakerk! You can accomplish this using a derived table.
Something like the below, replacing ... with whatever the default where
clause should be: view: fct_retail_shopify_combined_actuals_dt {
derived_table: { sql: SELECT transaction_type, v...
Hi nicola80! Can please you provide more information about the use case?
When you say "updates the data," do you mean writing back to the
database, displaying data in the report, or something else?
Hi Rups! Additionally, I noticed your retention dimension has type
durationday instead of duration_day, and your created dimension group
includes quotes in the sql parameter (sql: ${TABLE}."created At" ;;).
Can you try using duration_day and removing...
Hi vkhalpada! It's not currently possible to customize the "No results"
message in a Look. If you'd like to submit this as an idea for
improvement, please file a product idea or feature request within the
Looker platform. Here are directions on how t...
In LookML, you can use the suggestions parameter to hard-code a list of
values for the filter suggestions, or you can use the suggest_dimension
parameter to point to a different dimension for filter suggestions. You
can also set the filter suggestion...