Metabase 0.35 版本试用和新功能介绍

我们试用Metabase0.35.1版本,在试用过程中发现系统无法正常启动,删除历史数据库,重新初始化后Metabase0.3.5.1可以正常启动和使用,这个问题需要进一步研究和向社区咨询。0.35版本主要新增2个重要功能:

过滤自定义表达式Filter expressions, string extracts, and more

At long last, we’ve added the ability to create filter expressions in the custom question builder, which allow you to include ORs in your filters. You can now write expressions like, ([Subtota] > 100 AND [Tax] < 10) OR [Product.Category] = "Gizmo"

We’ve also added a whole host of new spreadsheet-like functions that can be used when creating filter expressions, custom columns, or custom aggregations. So you can now use things like case statements, string concatenation, or sumif and countif functions. Check out the documentation to see all the new functions you can use.

Filter expressions

该功能让用户探索数据时,可以使用复杂自定义表达式,OR、AND,之前只能通过编写SQL代码来实现复杂过滤条件。

SQL查询中引用已保存问题Reference saved questions in your SQL queries

You can now include the results of another saved question in your SQL queries using syntax like with Example as or select * from , where #123 is the ID of the saved question. (Note that you can only include questions based on the same database as the one you’ve currently selected.)

Question references

该功能可以让用户最大可能复用已定义问题,在SQL语句中引用;让SQL语句保持精简容易理解。

Metabase 0.35版本中还优化性能和修改一些BUGS,请参考文档

推荐文章

沪公网安备 31010702002009号