Lookml Measure Count Distinct Filtered | Unlock the power of your data in the cloud! Get hands-on with Google Cloud's core data services like BigQuery and Looker to validate your practical skills in data ingestion, analysis, and management, and earn your Associate Data Practitioner certification! | StudyCerts

Associate Data Practitioner

Unlock the power of your data in the cloud! Get hands-on with Google Cloud's core data services like BigQuery and Looker to validate your practical skills in data ingestion, analysis, and management, and earn your Associate Data Practitioner certification!

Fundamental

Prepare and test your skills

Track Readiness

Set Exam Goal

Fundamental

Prepare and test your skills

Track Readiness

Set Exam Goal

Lookml Measure Count Distinct Filtered

Section: Manipulate simple LookML parameters to modify a data model

Worked example. The correct answer is already marked and every option is explained below, so there is nothing to select here. To answer questions yourself, start the free trial.

A data team is updating an existing LookML view file (orders.view) to support new reporting requirements. The view already defines a base dimension for customer IDs:

dimension: user_id {
  type: number
  sql: ${TABLE}.user_id ;;
}

The business requires a new aggregate field that calculates the distinct count of customers who placed orders within the last 30 days. Following LookML modeling best practices for maintainability, how should this field be declared in the view file?

Declare a dimension with type: number, write sql: COUNT(DISTINCT ${TABLE}.user_id) ;;, and specify the timeframe inside the SQL definition.

Declare a measure with type: sum, set sql: ${TABLE}.user_id ;;, and omit filters so all rows are calculated.

Declare a dimension_group with type: time and define timeframes: [distinct_count] pointing directly to ${TABLE}.user_id ;;.

Declare a measure with type: count_distinct, reference the existing dimension using sql: ${user_id} ;;, and apply the date condition using the filters parameter.

Associate Data Practitioner

Lookml Measure Count Distinct Filtered

Related questions

An e-commerce company uses Looker to analyze transaction data. A data analyst needs to update the orders.view file to add a new field that calculates the total monetary revenue by summing the values of an existing sale_price dimension. Which LookML code block correctly defines this aggregate field?