Does metricflow not support having operations in sql? Is there a way to concatenate sql with having statements with mf?

Help
1

The problem I’m having

Does metricflow not support having operations in sql? Is there a way to concatenate sql with having statements with mf?

2

Hey @rourou! We don’t currently support having although it’s on our roadmap! You can’t inject SQL into the SQL MetricFlow generates, but you can add additional SQL if you’re querying via our JDBC. For example

select * from {{semanctic_layer.query()}} where... having...