This issue was moved to a discussion.
You can continue the conversation there. Go to discussion →
Impossible to use “Calculated columns” in “Custom metrics”, as they are not expanded. #15060
Closed
2 of 3 tasks
Labels
enhancement:request
Enhancement request submitted by anyone from the community
explore:dataset
Related to the dataset of Explore
When creating a “calculated column”
foo
(defined, e.g. ascol1 + col2
), I can't reuse it in the “custom metric”bar
, as the generated SQL query usesfoo
literally (rather than expanding into itscol1 + col2
definition).This fails as
foo
doesn't actually exist as a column in the table I query.Expected results
I want to be able to now build charts using that custom metrics:
This means, running the following query:
Actual results
However, trying to use the custom metrics in Explore fails:
Indeed, the following query is executed:
(I.e. the
feelslike_offset
calculated column is not expanded to its definition:temperature_feelslike - temperature
.)Environment
(please complete the following information):
1.1.0
3.8.9
node -v
Checklist
Make sure to follow these steps before submitting your issue - thank you!
The text was updated successfully, but these errors were encountered: