Слияние кода завершено, страница обновится автоматически
| title | redirect_from | |
|---|---|---|
Tables |
|
The Table option is good for looking at tabular data (duh), or for lists of things like users or orders. The visualization options for tables allow you to add, hide, or rearrange fields in the table you're looking at, as well as modify their formatting. Check out Everything you can do with the table visualization.
Open up the settings for your table visualization and you'll see the Columns tab, which displays all the columns currently being shown in the table. To hide a column, click the eye icon.
To manage these columns, including columns from linked tables, just click add or remove columns. Check the boxes next to the columns you want to show in the visible section, or uncheck to hide them.
When viewing tables, you can click on the gear icon in the bottom left to bring up the columns picker. Click Add or remove columns to search for and pick columns, including columns from related tables.
Admins (and people in groups with access to table metadata) can hide columns across your entire Metabase by marking them as hidden in the table metadata settings.
Hiding columns should not be used to secure sensitive information. Hiding columns in table visualization settings only affects the visibility of the columns in the visualization, not in the query results. Even people with view-only permissions to the question will be able to change the visualization settings and unhide columns. To exclude a column from the results of a specific query, uncheck the column in the "Data" block of the query builder.
To rearrange the order of the columns, simply click and drag any of the columns in the sidebar. You can also click on a column's heading in the table and drag the column to another position in the table.
To number the rows of a table, click on the gear icon in bottom left to bring up the table formatting sidebar. In the Columns tab, and toggle on Show row index. Metabase will add a column to the left of the table displaying a number for each row.
To change the width of a column, you can click and drag the edges of the column's header.
Click on a column heading and Metabase will present quick options for filtering and summarizing the data. The options for the column depend on the column's data type (ID, Text, Number, Date).
You can enter a value and filter the column value:
Text filters:
Number filters:
Clicking on Distribution will summarize the data by counting the rows and grouping the counts by the values in the column.
Get a count of unique values.
You can combine one or more text columns. For example, a first name column with a last name column.
You can tell Metabase how to combine the columns by specifying a separator, like a space, or comma, or the word "Danger".
From a datetime, you can grab:
Grab the domain or host from a URL or email. So if you have https://www.example.com/path/to/page#heading-on-page:
example.com
example
www
/path/to/page
Extracting parts of a URL or email is unavailable for MongoDB, SQLite, and SQL Server. For Druid, extracting domain and host is only available for the Druid-JDBC driver.
Add up all the values and group by a time period, generally by month.
To format the display of any column in a table, click on the column heading and choose the Formatting option (you can also get there by clicking on the gear on any column when in the Columns tab of the visualization settings).
The options you see will differ depending on the type of column you're viewing:
You can rename the column.
You can display the text on the left, right, or in the middle (i.e., centered) of the column.
You can toggle text wrapping, which is useful for columns with long text values like comments.
You can display a column as:
If you select link, you can also change the text displayed, and use parameters for both the link text and the link's URL.
For example, you could create a dynamic URL using a parameter from another column in the results:
{% raw %} https://www.example.com/{{category}} {% endraw %}
In the above example, Metabase would take the value for the category column for that row (in this case widget), and insert it into the URL:
https://www.example.com/widget
If you select image, and the text is a link to an image asset, Metabase will display the image in the table cell.
Date formatting options include the same options as Text formatting, as well as:
You can display the date on the left, right, or in the middle (i.e., centered) of the column.
Styles include:
If you select a date style that includes words, this toggle will abbreviate them. For example:
This option determines whether Metabase includes the time along with the date.
You can choose either 12-hour clock style, or 24-hour clock style.
This option displays a small horizontal bar next to each number in this column to show its size relative to the other values in the column.
Number styles include:
Gives you various options for how commas and periods are used to separate the number.
Forces the number to be displayed with exactly this many decimal places.
Multiplies each number in this column by whatever you type here. Just don't type an emoji here; there is a nontrivial chance that it will manifest a temporal vortex.
Lets you put a symbol, word, or whatever before or after each cell's value.
Currency columns have all the same options as numbers, plus the following:
Lets you change the unit of currency from whatever the system default is.
Allows you to switch between displaying the currency label as:
Lets you toggle between showing the currency label in the column heading or in every cell in the column.
Sometimes it's helpful to highlight certain rows or columns in your tables when they meet a specific condition. You can set up conditional formatting rules by going to the visualization settings while looking at any table, then clicking on the Conditional Formatting tab.
When you add a new rule, you'll first need to pick which column(s) should be affected. Your columns can be formatted in one of two ways:
You can set as many rules on a table as you want, and change the order in which those rules are applied. If two or more rules disagree with each other, the rule that's on the top of your list of rules will win. You can click and drag your rules to reorder them, and click on a rule to edit it.
When you add a table to dashboard, the table will be scrollable by default. You can paginate the rows by:
This auto-pivoting is distinct from the pivot table visualization.
If your table is a result that contains one numeric column and two grouping columns, Metabase will also automatically "pivot" your table, like in the example below. Pivoting takes one of your columns and rotates it 90 degrees ("pivots" it) so that each of its values becomes a column heading. If you open up the visualization settings by clicking the gear icon, you can choose which column to pivot in case Metabase got it wrong; or you can also turn the pivoting behavior off entirely.
Вы можете оставить комментарий после Вход в систему
Неприемлемый контент может быть отображен здесь и не будет показан на странице. Вы можете проверить и изменить его с помощью соответствующей функции редактирования.
Если вы подтверждаете, что содержание не содержит непристойной лексики/перенаправления на рекламу/насилия/вульгарной порнографии/нарушений/пиратства/ложного/незначительного или незаконного контента, связанного с национальными законами и предписаниями, вы можете нажать «Отправить» для подачи апелляции, и мы обработаем ее как можно скорее.
Опубликовать ( 0 )