You can change the default grouping of the conditions if needed. i.e., when you have three conditions, the third and the second will be joined, and the result will then be joined with the first. You can specify the join operator by clicking the link adjacent to the conditions.īy default, conditions from last to first will be grouped.
You can construct filter criteria with multiple conditions and join the condition using (AND) or (OR) operator. Optionįilters all the values that exactly match the search term.įilters all the values that do not match the search term.įilters all the values that contain the search term.įilters all the values that do not contain the search term.įilters all the values that start with the search term.įilters all the values that do not start with the search term.įilters all the values that end with the search term.įilters all the values that do not end with the search term. The following table lists the possible conditions for filtering. Wildcard filter allows you to filter by specifying filter criteria. A Search box is also available to find the required values. You can select multiple values using the shift + click option. Select the value to include or exclude from the chart. All the distinct values from the column will be listed with a checkbox. This allows you to filter the chart by actual value. The text type column can be filtered using the following options. You can add your custom ranges, Top/Bottom N and N% values by clicking Add New Range button under the corresponding option. If the listed values under each of the option does not meet your needs, Zoho Analytics allows you to define your own custom values.
For example Top 5%, will filter the top 5% values of the column. Top/Bottom N% is similar to Top/Bottom N option, except that it returns N% of values from the column. You can also specify another other column for ranking. The values will be computed based on aggregate function applied to the filter column. The chart will be sorted ascending or descending to illustrate the ranking.įor example Top 10 will filter the top 10 values in the column and Bottom 10, will filter the bottom 10 values in the column. This option allows you to rank the records and filter a specified number of Top/Bottom record. You can also add your own custom ranges for filtering. You can choose the required range to filter. This option allows you to filter data based on numeric ranges into which the values in the columns can be segmented Eg., 0 to 100, 101 to 250 etc., Filter tab will list a suggested range of values for filtering. You can select these values to filter them. All possible individual values of the dropped column will be listed in the filter tab. This option allows you to filter data based on individual values of the selected numeric column. Drag and drop the required columns in to the Filter shelf.Filter Shelf (Box) to drop the columns, second box displays the filter options and lists all the possible values for filtering and the third box displays added filter items. The Filters Tab has three boxes as shown in the screenshot below. Click Filters tab next to the Graph tab in the design area.Right click on the Chart name listed in the left side of the Workspace and select Edit.Click Edit Design option in the toolbar.To create a filter, after you have created the required chart (or pivot or summary view) The filtering options discussed in this topic can be applied only when you are designing a report (i.e., when you are in design mode) and not in the view mode. The Filtering options are the same for all types of reports that you create in Zoho Analytics - charts, pivot table & summary views.ĭepending on the data type of the column, you can filter specific numeric ranges, date ranges, individual values, top10, bottom 10 etc., Zoho Analytics also allows you to apply multiple filters (based on multiple columns) on a report. Zoho Analytics offers powerful Filtering options to filter the necessary records that are to be plotted in the report you create. User Filters for Numeric & Currency Column Types.User Filters for String (Categorical) Column Types.
0 kommentar(er)
