Grid Visualization

Grid visualization is the most basic visualization for displaying data in Gathr. It is a simple arrangement of rows and columns.

Configure Grid Visualization

Select your Grid visualization and open the Visualizations Panel.

The following configuration options are available for your Grid:

Data Configuration: It lets you manage columns in your Grid:
- Column
  - Conditional Formatting
- Sorting
Visual Configuration: It lets you configure the visual appearances and interactions of the Grid.
Visualization Level Filters: It lets you filter the data in the Grid without impacting other visualizations.

Refer here to learn more about Visualization Level Filters.

Data Configuration

Click on the icon for data configuration options.

Columns

You will see the columns in the Grid as per their order in the list of columns in the Visualizations Panel.

You can perform the following operations on columns.

Add Column

Drag the desired column from the Data Panel and drop it onto Visualizations Panel’s “Columns” section. You can also type the column name in the Data Panel to quickly find it.

Note: You can add a maximum of 70 columns to a Grid.

Edit Column Name

Click on the column name or the icon and type in the new column name

Remove Column

Click on the icon to remove a column from the Grid.

Reorder Columns

Select the column and drag it to the desired position and drop it.

Conditional Formatting

This allows you to show an image with your data by applying certain conditions. Multiple conditions can be combined as well.

To apply conditional formatting:

Click on the icon next to the column and select ‘Conditional Formatting’.
Format Column dialog box opens, you can Upload Image from any of the following ways:
- Choose Library and click on Search Image to select an image pre-bundled with Gathr.
- Choose File and click on Upload File to select a file from your system.
- Choose URL and Enter Image URL.
To Set the image Layout:
- Select the Show Data with image checkbox to display data as well as the image.
- Select a radio button to show data before/after the image.
Define the conditional formatting rule:
- Select the criteria from the drop-down.
- Provide threshold value.

An example of a conditional formatting rule is:

If any value in the column is greater than 10 then place an icon next to the value.

By applying this rule, you’d be able to see the values that meet this condition.

Go to Text and apply the Text on the following:
- Select a radio button to apply the text on a Cell or Row.
Select a Text Style as per your requirements.
Enter the text to displayed in the Pivot chart, click on ‘Apply’ and close the Format Column dialog box.
This icon indicates that the conditional formatting is applied to the column.

Update Conditional Formatting:

To update the condition for a column:

Click on the icon and select Conditional Formatting.
Change the criterion or Format style.
Go to Text and click ‘Apply’.

Note: You can view the condition or criteria or format style changes listed on the left side panel below Applied Rules as highlighted in the image below.

Remove Conditional Formatting

To remove a condition:

Click on the icon and select Conditional Formatting for the desired column. Format column dialog opens.
Hover over the criteria below Applied Rules and click on the icon to remove the condition.

Sorting

Sorting allows you to change the order of data making it easier to find what you’re looking for. You can do a multi-column sort on a Grid e.g., the first sort on ‘Assignee’, and then on ‘Priority’.