![]() This example also illustrates how to add multiple filters to a field. ![]() In this example, the measure will count distinct IDs that were created in the past seven days and were not from users with disabled accounts. The examples below outline some solutions for common use cases: There are many ways to use filters for measures. See the Creating a dynamic filtered measure section later on this page for reference. This approach allows users to select filter values that only apply to a specific measure, without filtering the entire query in a global WHERE clause. You can also use filters with Liquid parameters and templated filters to create dynamic filtered measures with a filter value that can change dynamically based on user input on a dashboard or Look. Place the entire filter expression in quotation marks, as shown in the following examples. Refer to Looker's filter notation for details on how to write valid filter expressions. It works only with the following measure types that perform aggregation: Save money with our transparent approach to pricingĪ set of dimension names and corresponding Looker filter expressionsįilters is an optional list of filter expressions that are applied to a measure calculation. Rapid Assessment & Migration Program (RAMP)
0 Comments
Leave a Reply. |