If you want to add complex conditions, and the functions are not purposed in th the condition part, you can do it in advanced mode.

To use this function confortably, you need to have Clickhouse SQL skill and familiar with the data model, please contact the BI4H team for an introduction of use.

If you do not see this option, please contact the BI4H support team.

when this option is activated, you can customize you queries via the window below.

Here is the documentation on Clickhouse SQL.

https://clickhouse.com/docs/en/sql-reference