[Explore][Control] Allow selecting ad-hoc metrics in filters

[ktmud]

When adhoc filters were first added ( #4909 ), it can select from selected adhoc metrics. Part of the code is also still there, but the feature somehow stopped working from certain point.

Could be related to #12095

[ktmud]

I discovered this while working on #13221

Will take a look once more refactoring is done.

[junlincc]

Will take a look once more refactoring is done.

happy to take it on while we are refractor the filter component in a few weeks. @ktmud
@zuzana-vej can you provide a complete list of expected behavior in ad hoc filter and metric popover, + new features suggestion (i.e, in-place saving metric)?

[ktmud]

Two feature requests I've been thinking on for a while:

1. Adhoc Column: similar to adhoc metrics, users should also be able to create adhoc calculated columns (dimensions)
2. Adhoc metric/column in other controls: users should be able to select already created adhoc metrics and columns in other controls (e.g. sort by and filters).

[villebro]

Two feature requests I've been thinking on for a while:

1. Adhoc Column: similar to adhoc metrics, users should also be able to create adhoc calculated columns (dimensions)

2. Adhoc metric/column in other controls: users should be able to select already created adhoc metrics and columns in other controls (e.g. sort by and filters).

Big +1 for adhoc columns!

[junlincc]

@villebro @ktmud hey both, please take a look the draft 1 year roadmap for Explore and send me comments, thoughts before I finalize? I believe we captured most of the significant items requested by the community.
shared a gsheet link with you, please comment directly on it. 🙏

[zhaoyongjie]

Two feature requests I've been thinking on for a while:

1. **Adhoc Column:** similar to adhoc metrics, users should also be able to create adhoc calculated columns (dimensions)

2. **Adhoc metric/column in other controls:** users should be able to select already created adhoc metrics and columns in other controls (e.g. sort by and filters).

I'm trying to redesign the semantic layer, it might help. these are good requests.

[junlincc]

Thank you all for suggesting new features.
committed to both.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[rusackas]

Since this has gone stale, and adhoc columns are effectively "a thing" nowdays, I'll close this out, but if there's more to track down, maybe we can open a fresh thread with updated context.