I am getting this error message on an explore when trying to pivot across a date type. This is the error I am receiving:
The dimension that I am trying to pivot on is set up like this in the view:
dimension_group: accounting_period {
type: time
timeframes: [
raw,
date,
week,
month,
quarter,
year
]
convert_tz: no
datatype: date
sql: ${TABLE}.accountingPeriod ;;
}
Any advice on what this error means here?
I am also seeing this error when pivoting on a dimension_group with type time
This is a bug, please reach out to support for getting this filed and addressed.
I am also having this error when dealing with a data related field.
Just talked to a customer support from Looker. It is likely due to a legacy feature that is no longer supported in the latest Looker version. A temporary fix would be enabling the āUse Legacy LookML Runtimeā feature under Admin >> Legacy Feature>> Use Legacy LookML Runtime.
@cherubic Are there any downsides to enabling that feature? Any capabilities that I would not have by enabling it?