Add Date Field in Drill Field

Looker Q&A Looker
,
1

I have an END Date Field in my View that I want to include into a measure drill field. The End date is defined as:

dimension_group: sf_bill_period_end_date {
    label: "Billing Period End"
    type: time
    timeframes: [
      date,
      week,
      month,
      quarter,
      year
    ]
    sql: ${TABLE}.sf_bill_period_end_date ;;

I want to include this END DATE into one of my Measures “Budget Spend” (below) but when drill down, I do not see the END DATE in the row level data.

measure: Budget_Spend{
  type: sum
  label: "Total Gross Budget Spend"
  sql: ${TABLE}.sf_actual_gross_budget_spend ;;
  value_format:"$#,##0;($#,##0)"
  drill_fields: [spendrevenue_details*]}

set: spendrevenue_details {
  fields: [sf_billing_period.sf_bill_period_owner_name,
    sf_billing_period.sf_bill_period_end_date]}
1 Like
2

I also seem to be running into an issue where my date is defined as a drill field but is not showing

3

@bpatel-16770205 @Samuel_Stelzner

The problem with the code is that sf_bill_period_end_date is the name, but you need the timeframe after this field to determine what to pull in: sf_bill_period_end_date_date, sf_bill_period_end_date_month, etc will be the field in the drills needed.