Filter box on a metric

[jpetot]

Hi,

I want to create a filter box for my dashboard.
I want to apply the filter control on a metrics (not a columns)

Expected results

I expect metric or custom sql space in the filter controls bar

Actual results

currently I can only choose my columns

Screenshots

Environment

(please complete the following information):

• superset version: superset website
• python version: python --3.7
• node.js version: node -v
• npm version: npm -v

Checklist

Make sure these boxes are checked before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if there are any.
• I have reproduced the issue with at least the latest released version of superset.
• I have checked the issue tracker for the same issue and I haven't found one similar.

Additional context

Add any other context about the problem here.

[thunderbird57]

I have exactly same problem

[mistercrunch]

The filter box "visualization" could have an option to reuse the FilterControl. In theory this should work

[mistercrunch]

Workaround idea: creating a "bracket" column either as a physical column or as an expression. Ex: instead of an integer age column, you can expose a 0-9, 10 to 19, ...

But that's just a workaround. Curious how other dashboarding tools do it. I remember seeing range sliders and such on other tools.

[thunderbird57]

Workaround idea: creating a "bracket" column either as a physical column or as an expression.

Yes this work in cases where we have static ranges known. We have created some calculated columns to define filter ranges and then use it dimension filters.

[mistercrunch]

Longer term we want to make filter box as a dashboard native component (as opposed to the current "special visualization" status) and completely redesign it. SIP-34 touches on some ideas around contextual filter bars.

[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.