![]() ![]() If the columns are grouped, then the maximum value will be applied at group level. If the columns are grouped, then the minimum value will be applied at the group level. If grouping is applied, it then provides the total number of records at the group level. Returns a count of the number of records in the column. In case grouping has been applied, it will return the average value at the group level. ![]() ![]() Returns arithmetic mean of all the values in the column. If the columns are grouped, summation will be applied at the group level. Returns the sum of all the values in the column. Listed below are the sets of summary functions supported by Zoho Analytics for a tabular view and their functionalities. When you apply a summary function over a column, a summary row for each group (block and section) and a grand summary row for the view will be displayed. Zoho Analytics enables you to apply one or more summary functions to the columns in the Tabular View. You can further add Filters, User Filters, and customize the created tabular view as required. You have successfully created a Tabular View in Zoho Analytics. The final table will be as displayed below. Once you are satisfied with the generated Tabular View, provide a Name and Save the changes made. To do this, add Product Category to the Group by section shelf and Region to the Group by block shelf and click the Click Here to Generate Report button. We will add further details to this table by grouping them into sections based on Product Category and blocks based on Region. The generated Tabular View will be displayed as below. To do this, we will add the following data columns from the Sales Details table into Columns shelf with the corresponding function selected, Column Name We will create a Tabular View to analyze the Sales and Cost of products sold based on Date and Customer Name. Let's look at how to create a Tabular View with groups and summaries from a Sales data table like the one shown below. We will understand about Tabular View shelves using an example. When you add multiple columns, they will be displayed as categorized layers (a group within a group) of data horizontally. Group by block: Columns dropped in this shelf will group your Tabular View data rows into blocks. You can only have one sectional grouping in a Tabular View. Group by section: Columns dropped in this shelf will be used to group the Tabular View into sections. You can drop any number of columns in this shelf. The following is a brief description of each shelf in the Design Area of the Tabular View.Ĭolumns: Data from the columns dropped in this shelf will be added as columns in the Tabular View. ![]() You can only create a Tabular View using data from a single data table. Note: Currently, you cannot create a Tabular View combining data from multiple data tables in Zoho Analytics. You can customize the look and feel of your tabular view using the various customization options available. In the Save As dialog box that appears, type a Name and Description for the tabular view and choose the folder where the view is to be saved.Ī tabular view will be created and saved in your workspace. Once you have added the required data, click the Save button in the toolbar.You can also select the checkbox adjacent to each column to auto-place the columns into the appropriate shelves. In the Tabular View Edit Design page that opens, drag and drop the columns from the Column List pane on the left to the corresponding shelves in the Design Area on the right.Alternatively, you can also create a new Tabular View by opening the corresponding data table and clicking the New > New Tabular View option in the toolbar. In the Select Base Table dialog box, choose the data table on which you want to create the Tabular View and click OK.Open the workspace containing the data tables on which you want to create a Tabular View.You can create a Tabular View in Zoho Analytics by following the below steps: In this section, we will see how to create a Tabular View: With Tabular View, you can easily summarize, structure, group, filter, and customize data the way you want. A Tabular View as the name implies is a simple table-like report, that can be created with an intuitive drag and drop interface, over your data tables. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |