metricflow
metricflow copied to clipboard
dbt-labs
[SL-1528] [Feature] Support add "having" parameter
Is this your first time submitting a feature request?
- [X] I have read the expectations for open source contributors
- [X] I have searched the existing issues, and I could not find an existing issue for this feature
- [X] I am requesting a straightforward extension of existing metricflow functionality, rather than a Big Idea better suited to a discussion
Describe the feature
Can we support passing in the having parameter when querying?
Describe alternatives you've considered
No response
Who will this benefit?
No response
Are you interested in contributing this feature?
No response
Anything else?
No response
We are dealing with some cases where we need to filter data based on specific criteria, such as when a measure is greater than a certain value (xx) or less than another value (yy). We are looking for guidance on how to define a semantic model in MetricFlow to handle these types of scenarios.
@kingduxia We've heard that exact use case come up several times. We have work planned to enable this since it's really common.
@UncleFB I wrote up some more details on how we would support this here https://github.com/dbt-labs/metricflow/issues/1018. Would love your feedback!