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]}
I also seem to be running into an issue where my date is defined as a drill field but is not showing
@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.