Find & Replace operation is Case Sensitive i.e., upper and lower letters are not considered as equivalent.This is applicable only when you use the Bulk Update option. Do not replace null values: Select this option when you do not want to replace existing null values in the column with the value specified in Replace With.This option is selected by default for number and currency type columns. Match entire cell: Select this option to limit your search results only to cells whose entire contents match with the Find What value that you have provided.On selecting this option the Find what text box will be disabled. Bulk Update: Select this option if you want to replace all the values in the column with the value specified in the Replace With text box.Replace With - Specify the data to replace in this field.Find - Specify the data to be searched in this field.Column Name - Select the column where you want to find and replace data.Specify the following details to replace data. To find and replace data click More > Find and Replace. This option will be enabled only to users who have been provided Write permission by the Administrator.This feature can be very useful especially when you are working with large sets of data and have the need to quickly correct/rectify issues in your data set. Find and Replaceįind and replace option can help you to locate a value in a column and replace it with another value. You can also sort the columns using the arrow icon in the column header. 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.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.The sort options available in Zoho Analytics are: To sort the columns, click Sort and then select the required options. For example, you can sort a column of dates by their date order, while a column of numbers can be sorted numerically. You can sort a column numerically, alphabetically or by date depending on its data type. Zoho Analytics allows you to rearrange rows in a table by sorting values in one or more of its columns. Delete Rows: Select this option to permanently delete the filtered rows from the table.How to save a filter for repeated usage is discussed below. Save/Save as: Click this option and type the name in the dialog box that appears to save your filter for later/repeated use.Clear: Click this option to remove all the filters applied.You can also use icon at the column header to hide/show filter pane. Hide: Click this option to hide filter pane.The following is a brief description of various options provided in the Filter Pane when you apply filters. You will also find some filter panel option to apply the filter. The filter panel will open.ĭepending on the data type of the column, Zoho Analytics offers various filtering options like filter based on specific numeric ranges, date ranges, individual values, partial match etc. You can also apply filters on multiple columns at a time. Zoho Analytics provides a Filter option to easily filter records in your table based on criteria that you specify. Note that the search operation will search across data contained in all columns of the table. All the records containing the specified keyword will be filtered and displayed as shown below. 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. The Search box on the toolbar can be used to locate records in a table that matches the keyword that you specify. Zoho Analytics allows you to quickly search for specific records within a large set of data. Refer to the topic Sharing and Collaboration to know more about sharing. These options will be enabled only to users who have been provided with appropriate permissions during sharing by the Administrator.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |