# Working with Tables

A ManageEngine Analytics Plus workspace could contain a collection of tables. Two tables could be related to each other using lookup columns, thus enabling you to model a relational workspace (Refer Relating tables using Lookup columns). You can create any type of report over these tables which contain the actual data.

Type of a column defines the nature of values a column can contain and the operations that can be done over the same. e.g., an *Age* column could be "*Positive Number*" type. This column can contain only positive numbers and you could apply arithmetic operations over the same.

## Table Operations

- [Searching](#search)
- [Filtering](#filter)
- [Sorting](#sort)
- [Find and Replace](#find)
- [Show/Hide Columns](#show)
- [Freeze Columns](#freeze)
- [Reorder and Resize Columns](#reorder)
- [Split columns](#splitcolumn)
- [Custom Sort](#custom-sort)
- [Changing the column properties](#column-properties)
  - [Format a column](#format-column)
  - [Dynamic Image/URL](#Dynamic-URL)
  - [Conditional formatting](#conditional-formatting)
  - [Set chart drill down path](#chart-drilldown)
  - [Rename column](#rename-column)
  - [Marking columns as personally identifiable information](#marking-pii)
  - [Change the data type of a column](#change-datatype)
  - [Changing a column to lookup](#change-to-lookup)
  - [Analyze column](#analyze-column)
- [Copying a Table](#copy)
- [Exporting a Table](#export)
- [Sharing a Table](#sharing_table)
- [Publishing a Table](#publish)

ManageEngine Analytics Plus offers a range of interactive options to work with a table. Some of the options include Filter, Sort, Format, Find and Replace values, Freeze, and Show/Hide Columns. ManageEngine Analytics Plus also allows to Export, Share and Publish a table.

**Note:**

- These options will be enabled only to users who have been provided with appropriate permissions during sharing by the Administrator. Refer to the topic Sharing and Collaboration to know more about sharing.

## Searching

ManageEngine Analytics Plus allows you to quickly search for specific records within a large set of data. The search box on the toolbar can be used to locate records in a table that matches the keyword that you specify.

To search for records, type the keyword that you want to search for in the search box and click on the magnifying glass icon next to the search box. All the records containing the specified keyword will be filtered and displayed. The search operation will search across data contained in all columns of the table.

## Filtering

ManageEngine Analytics Plus provides a Filter option to easily filter records in your table based on criteria that you specify. Depending on the data type of the column, ManageEngine Analytics Plus offers various filtering options like filters based on specific numeric ranges, date ranges, individual values, partial match, etc. ManageEngine Analytics Plus also allows you to filter on multiple columns at a time.

### Filter Pane Options

Following is a brief description of various options provided in the Filter Pane when you apply filters.

- **Hide**: Click this option to hide the filter pane. You can also use icons at the column header to hide/show the filter pane.
- **Clear**: Click this option to remove all the filters applied.
- **Save/Save as**: Click this option and type the name in the dialog box that appears to save your filter for later/repeated use.
- **Delete Rows**: Select this option to permanently delete the filtered rows from the table.

## Sorting

ManageEngine Analytics Plus allows you to rearrange rows in a table by sorting values in one or more of its columns. You can sort a column numerically, alphabetically, or by date depending on its data type.

The sort options available in ManageEngine Analytics Plus are:

- **Sort Ascending** - Sorts text data in ascending alphabetical order (A to Z), numbers from smallest to largest (0-9), and dates from oldest to latest.
- **Sort Descending** - Sorts text data in descending alphabetical order (Z to A), numbers from largest to smallest (9-0), and dates from latest to oldest.

## Find and Replace

The find and replace option can help you to locate a value in a column and replace it with another value. This feature is useful especially when working with large sets of data.

**Note:**

- This option will be enabled only to users who have been provided *Write* permission by the Administrator.

### Options in the Find and Replace

- **Bulk Update**: Replace all the values in the column with the value specified in the Replace With text box. The Find what text box will be disabled.
- **Match entire cell contents**: Limit search results only to cells whose entire contents match the Find What value. Selected by default for *number* and *currency* type columns.
- **Do not replace null values**: Do not replace existing null values when using Bulk Update.

**Couple of Points to Note:**

- Find & Replace operation is case sensitive.
- To find or replace an empty/null value, leave the corresponding boxes empty.
- Currency ($) and Percentage (%) symbols cannot be used in Find & Replace fields for currency and percentage data types.
- Find & Replace will be applied over filtered data if a filter is already applied.

## Show/Hide Columns

ManageEngine Analytics Plus lets you show or hide columns in a table view.

## Freeze Column

The Freeze Column option allows you to keep specific columns always visible in the table even when you scroll horizontally across the screen.

## Reorder and Resize Columns

ManageEngine Analytics Plus allows you to rearrange the order of columns in a table using drag and drop.

## Split a Column

Analytics Plus allows you to split text-based columns using separators such as comma, space, ampersand, etc. This can be used to extract user IDs from email addresses, separate first and last names, etc.

The Split Column can be applied over columns with the following data type:

- Text
- Multiline
- Email
- URL

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/splitcolumn.png)

## Custom Sort

The Custom Sort option for Text data types allows you to define the sorting order to be applied. This order is applied globally to all reports that are created using this column.

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/customsorting-workspace.gif)

### To apply custom sort

1. Select the column and click **More** and choose **Custom Sort** from the drop-down menu.

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/customsortorder.png)

2. To define the sort order:
   - Use the **drag handle** icon to move values up or down.
   - Use the **arrow** icons to move values up or down one position at a time.

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/order-priority.png)

3. Click **Apply**.
4. Click **Yes** in the confirmation message.

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/sorting-yes.png)

The custom sort order can also be defined while creating reports. Refer to the [Custom Sorting in reports](https://www.manageengine.com/analytics-plus/cloud-help/chart/working-with-charts.html#sorting-chart) section to learn more.

## Changing the column properties

Analytics Plus lets you change the properties, such as format, name, data type, etc., of a column at any time. The changing column properties option is disabled for shared users.

### Format a column

#### Formatting options

| Option | Description |
|---|---|
| **Alignment** | Align the cell values horizontally in the Left, Right, and Center positions. |

#### Numeric Data Type

| Option | Description |
|---|---|
| **Units** | Format values as None, (Thousands) K, (Lakhs) L, (Millions) M, (Crores) C, (Billions) B, combinations, or Auto (User Locale Specific). |
| **Separator** | Select decimal and thousand separators, apply locale settings, and choose display format (International/Indian). |
| **Currency Symbol** | Choose the currency symbol (for currency columns). |
| **Negative Number Display** | Display negative numbers within parenthesis or with a negative sign. |
| **Decimal Places** | Set number of decimal places for decimal, currency, and percentage columns. |

#### Date Data Type

| Option | Description |
|---|---|
| **Alignment** | Align cell values. |
| **Choose Date Format** | Select or specify a custom date format. |

#### Duration Data Type

| Option | Description |
|---|---|
| **Alignment** | Align cell values. |
| **Choose Duration Format** | Select or define a custom duration format. [Click here](https://www.manageengine.com/analytics-plus/cloud-help/table/custom-duration-format.html) to learn more. |

#### String or Category Data Type

| Option | Description |
|---|---|
| **Alignment** | Align cell values. |

#### URL Data Type

| Option | Description |
|---|---|
| **Alignment** | Align cell values. |
| **Alternate Text** | Provide substitute text instead of the actual URL. |
| **Image** | Replace image URLs with corresponding images. |

#### Alternate text in tables

- **Sorting**: Sorting is performed based on actual URLs.
- **Copy and Paste**: Copies actual URL corresponding to the alternate text.
- **Exporting**: Exports actual URLs.

#### Image URL in Tables

To convert image URLs into images:

1. Open the table, right-click the image URL column, and select **Format Column**.

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/table-image-url-column-format-column-option.png)

2. Choose **Image** from the **Display As** drop-down (image size must not exceed 200 KB).

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/table-image-url-format-column-popup-display-as.png)

3. Choose required **Image Dimension** or select **Custom** to provide custom dimensions.

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/table-image-url-format-column-popup-image-dimension.png)

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/table-image-url-format-column-popup-image-dimension-custom.png)

4. Click the **Ratio** icon to maintain aspect ratio.

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/table-image-url-format-column-popup-image-dimension-custom-ratio-icon.png)

5. Click **OK**.

**Note:** Export the view in HTML file format to display converted images while exporting.

### Dynamic Image/URL

Analytics Plus lets you associate a Plain Text column with a URL column. This enables users to navigate directly to a specific page by clicking the plain text field in a dashboard or report. You can also link an image URL to the Plain Text column, allowing an icon to be displayed alongside the text.

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/formatcol.png)

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/focol.png)

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/aut.png)

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/networkissue.png)

**Note:**

- The **Associate URL** and **Associate Image** configurations cannot be changed in the report settings.
- Association is not supported for Sankey, Sunburst, table and Web charts.
- Associated details will be displayed on hover for charts.
- When used as a User Filter, the filter drop-down displays the image alongside its corresponding value.

### Conditional formatting

Analytics Plus allows you to highlight cells in a column with different background and font colors based on a specified condition.

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/analyticsplus-table-conditional-formatting-option.png)

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/analyticsplus-table-conditional-formatting-dialog.png)

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/analyticsplus-table-conditional-formatting-ex.png)

### Set chart drill down path

Analytics Plus allows you to click any data point in the chart and visualize the underlying data as a new chart. You can set the drill down path for any given column in the table or query table.

### Rename column

Analytics Plus allows you to rename column names in tables:

**Option 1**: Double-click the column header and enter the new name.

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/analyticsplus-table-rename-column-option-2.png)

**Option 2**: Right-click the column and choose **Rename Column**.

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/analyticsplus-table-table-rename-column-option1.png)

Enter the **Column Name** and **Description**.

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/analyticsplus-table-rename-column-dialog.png)

### Marking columns as personally identifiable information

Analytics Plus allows you to mark columns as Personally Identifiable Information (PII).

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/analyticsplus-table-mark-as-personal-data-option1.png)

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/analyticsplus-table-mark-as-personal-data-option2.png)

### Change the data type of a column

Analytics Plus allows you to change the data type of a column.

### Changing a column to lookup

Analytics Plus allows you to change any table column to a lookup column.

1. Open the required table and select the column.
2. Right-click and choose **Change to Lookup Column**.

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/analyticsplus-table-change-lookup-column-option.png)

3. Choose the column to lookup from the **Column to Lookup** drop-down.
4. Click **Save & Close**.

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/analyticsplus-table-change-lookup-column-dialog.png)

Learn more about lookup columns [here](https://www.manageengine.com/analytics-plus/cloud-help/table/add-rows-columns.html#lookup).

### Analyze column

Analytics Plus can automatically analyze your column's data and create sample reports.

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/analyticsplus-table-analyze-column-option.png)

## Copying a Table

ManageEngine Analytics Plus allows you to save a copy of a table in your workspace. On copying, all formatting and formulas will be retained.

Steps:

- Open the table.
- Click the More Options icon near the table name and select **Save As**.
- Specify a name in the **Name** field.
- Select the folder in **Save in folder**.
- Use **With Data** option to copy with or without data.
- Use **Retain Lookup** option to retain lookup columns.
- Click **OK**.

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/22_11.png)

## Exporting a Table

ManageEngine Analytics Plus allows you to export tables into CSV, PDF, HTML, or Excel (XLS) formats.

Steps:

- Open the table.
- Select **Export** in the toolbar.
- Choose format and configure export settings.

Export formats:

- **CSV** - Comma Separated Value file.
- **PDF** - Portable Document Format.
- **HTML** - HTML file format.
- **Excel (XLS)** - Excel file.

![](https://cdn.manageengine.com/sites/meweb/images/analytics-plus/cloud-help/22_12.png)

## Sharing a Table

In ManageEngine Analytics Plus, you can share your table with other users and set specific permissions. Refer to the topic Sharing and Collaboration to know how to share a table.

**Note:**

- Share option will be enabled only to users who have been provided that permission during sharing by the Administrator.

## Publishing a Table

ManageEngine Analytics Plus allows you to publish/embed tables into websites or as easy-to-access URLs. You can control access privileges and permissions for users.

**Note:**

- This option will be enabled only to the Administrator and Owners of the workspace.

Related topics:  
[Add Rows and Columns](https://www.manageengine.com/analytics-plus/cloud-help/table/add-rows-columns.html) |  
[Adding Formulas (Calculations)](https://www.manageengine.com/analytics-plus/cloud-help/table/add-formulas.html) |  
[Relational Data Modeling](https://www.manageengine.com/analytics-plus/cloud-help/table/relational-data-modeling.html) |  
[Joining Tables](https://www.manageengine.com/analytics-plus/cloud-help/table/joining-tables.html)