Hello,
I try to follow the metholodgy explained here to compare 2 “time” to hire from differents periods of time :
But the date column in big query is in timestamp format and i can’t use my filters, i see this error message :
#####################DATE######################
dimension_group: Date {
type: time
timeframes: [
raw,
date,
week,
month,
year
]
datatype: datetime
sql: ${TABLE}.date ;;
}
##################Filters#########################
filter: timeframe_a {
label: "Période 1"
type: date_time
default_value: "1 month ago for 1 month"
}
filter: timeframe_b {
label: "Période 2"
type: date
default_value: "2 months ago for 1 month"
}
dimension: group_a_yesno {
hidden: yes
type: yesno
sql: {% condition timeframe_a %} ${Date_date} {% endcondition %} ;;
}
dimension: group_b_yesno {
hidden: yes
type: yesno
sql: {% condition timeframe_a %} ${Date_date} {% endcondition %} ;;
}
measure: TTH_a {
type: average
sql: ${Time_to_hire_day} ;;
filters: [group_a_yesno: "yes"]
}
measure: TTH_b {
type: average
sql: ${Time_to_hire_day} ;;
filters: [group_b_yesno: "yes"]
}
##########################################################################
Could you please help me ? Thank in advance