Only 2 hours of trying to find a reason and I realised that when using Dynamic Timeframe:
https://help.looker.com/hc/en-us/articles/360001288468-Dynamic-Timeframes-for-Dimension-Groups
my drill fields on a view level, aka:
view: name {
drill_fields: [
id,
name,
country
}
measure: count {
type: number
sql: ${id}
}
}
Are not going to work. The reason why parameters would stop drilling being available is still unknown, so this is more of a FYI in case you find yourself wondering.
Even defininig drill fields in each measure is not going to work
We are having a similar issue with our drill fields. Would love some more insight from Looker on why this may be the case
They don’t know and I haven’t heard from them for 8 days about this issue