![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |