Add Date Field in Drill Field

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 2 688
2 REPLIES 2
Top Labels in this Space