Can I extend a view and use one of its dimensions in derived table sql query?
Here is an example of what I am trying to do, where timerange_start is a dimension from the extended view timerange
view: derived_table_view {
extends: [timerange]
derived_table: {
sql: SELECT *
FROM some_table
WHERE some_table."start" = ${timerange_start}
}
}
Currently this code results in <ERROR: column "timerange_start" does not exist >