![]() Spreadsheets are a powerful tool, and everyone knows how a table works, right? If your organization is on the smaller side, doesn’t have huge volumes of data to process, and is happy processing that data manually, stick with spreadsheets. BI platforms offer some pretty cool features and can be quite useful, but if your organization’s data needs are satisfied by a spreadsheet application like Excel or Google Sheets, it’s okay if you don’t want to mess that up. It’s important not to immediately jump ship every time a shiny new tool arises. Your data needs are likely to grow alongside your organization, and the features that a BI tool can help your organization level up. Still, adopting a BI platform can be a huge benefit in the long run. Data analysts with every BI tool at their disposal will still usually use Excel on a regular basis. Spreadsheets are everywhere for a reason - they’re familiar and efficient - and serve a purpose even in the most cutting-edge data environments. List of expressionsįor a tutorial on expressions, see Custom expressions in the notebook editor.If you’re used to working exclusively in the world of Excel, Google Sheets, or Libreoffice Calc, you may wonder what the point of a business intelligence platform is. This expression would return rows where Created At is between Januand March 31, 2020, or where Received At is after December 25, 2019. Conditional operatorsĪND, OR, NOT, >, >= (greater than or equal to), 100 OR floor() "" You can’t currently do math on timestamp columns (we’re working on adding new date functions soon, so stay tuned). ![]() You can use parentheses, ( ad ), to group parts of your expression.įor example, you could create a new column that calculates the difference between the total and subtotal of a order: =. Use +, -, * (multiply), / (divide) on numeric columns with numeric values, like integers, floats, and double. Functionsįunctions, by contrast, do something to each value in a column, like searching for a word in each value ( contains), rounding each value up to the nearest integer (the ceil function), and so on. So while you could create a custom column with the formula +, you could not write Sum( + ), unless you were creating a custom metric expression (that would add up all the subtotals and taxes together). Aggregations functions can only be used in the Summarize section of the notebook editor, because aggregations use values from all rows for that column. AggregationsĪggregations take values from multiple rows to perform a calculation, such as finding the average value from all values in a column. There are two basic types of expressions, Aggregations and Functions. You can check out a full list of expressions in Metabase, or walk through a tutorial that shows you how you can use custom expressions in the notebook editor. ![]() This page covers the basics of expressions. You could use = / to create a new column, which you could name “Item price”. = share( > 50) would return the percentage of orders with totals greater than 50 dollars. The expression = contains(, "Metabase") would filter for rows where the comment field contained the word “Metabase”. ![]() When using the query builder, you can use expressions to create new: ![]() To use custom expression, create a Custom Column (where the custom expression is used as a Field Formula to calculate values for the new column), or click on Filter or Summarize and select Custom Expression. Custom expressions to create filters, metrics, and custom columns You can also skip to the complete list of expressions. They are the power tools in the notebook editor of the query builder that allow you to ask more complicated questions. Custom expressions are like formulas in spreadsheet software like Excel, Google Sheets, and LibreOffice Calc. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |