Formatting tables is easier and faster in the Properties Panel. Let's learn about the six table formatting options.
Add a Table View to any node in your Dataflow or Data App. Select any node and use the Transform (+) button to open the list of options and select Table View.
To add a Table to a Data App, drag and drop the output of a node to the Data App workspace.
Select a table, either in a Dataflow or in a Data App, to see the complete list of table transform properties.
There are six transformation options under the Configuration section in the Properties Panel. If you do not see this, make sure the properties panel is open on the right.
There is a number in a parenthesis that indicates how many fields are being edited for each transformation. The table is grouped by one field in the example below - shown byGroup by (1).
Use the dropdown to select one or many columns to hide in your table. To quickly deselect all columns, click the none option in the dropdown.
Click the OR button to change the filter operator to AND, and vice versa to switch back to OR. Use the +Add Condition button to create more filter conditions, and click the "x" button to the right of each dropdown to remove a condition.
Use the Sort dropdown to select a field. Click on the button to the right of the dropdown to switch from ascending to descending. Use the +Add Sort button to create multiple sorting conditions and click the "x" button to the left of each dropdown to remove a condition.
Use the Group by dropdown to select a field. Use the +Add Column button to create multiple groups and click the "x" button to the right of each dropdown to remove a group.
Use the Column dropdown to select a field and the Order By dropdown to pick which order to place the selected column. Use the second Column dropdown to choose a reference column for the options "Before" or "After".
Use the +Reorder Another button to create multiple groups and click the "x" button to the right of each dropdown to remove a condition.
Use the Column dropdown to select a field, and the Unit dropdown to choose a number format. You could specify the number of decimal places by typing in the Decimal places textbox.
Use the +Format Another button to select more columns and click the "x" button to the right of each dropdown to remove a condition. Each column you format can have its own unique format options.
This section in the Properties Panel lets you select a type of data interactivity for your table. Interactions are set by default; however, you could remove this by unchecking the Allow Interactions box.
Cross-filtering (default) will reduce a table and show only the records that match a selection made in a chart within the same Data App. Cross-highlighting will highlight records in a table.
Absolutely! Open the Properties Panel to add and remove formatting option. Each table will maintain its unique configuration.