[null, null, {"document_url": "http://wiki.izenda.us/Guides/ReportDesign/4.0-fields-tab", "unformatted_src": "/Guides/ReportDesign/4.0-fields-tab/fields_tab_no_dashboard_fields.png", "src": "https://wiki.izenda.us/Guides/ReportDesign/4.0-fields-tab/fields_tab_no_dashboard_fields.png", "formatted_filename": "fields tab no dashboard fields", "alt_text": "Fields tab"}, null, {"document_url": "http://wiki.izenda.us/Guides/ReportDesign/4.0-fields-tab", "unformatted_src": "/Guides/ReportDesign/4.0-fields-tab/field_dropdown.png", "src": "https://wiki.izenda.us/Guides/ReportDesign/4.0-fields-tab/field_dropdown.png", "formatted_filename": "field dropdown"}, null, {"document_url": "http://wiki.izenda.us/Guides/ReportDesign/4.0-fields-tab", "unformatted_src": "/Guides/ReportDesign/5.0-Filters-tab/filter_delete.png", "src": "https://wiki.izenda.us/Guides/ReportDesign/5.0-Filters-tab/filter_delete.png", "formatted_filename": "filter delete"}, null, {"document_url": "http://wiki.izenda.us/Guides/ReportDesign/4.0-fields-tab", "unformatted_src": "/Guides/ReportDesign/5.0-Filters-tab/filter_create_below.png", "src": "https://wiki.izenda.us/Guides/ReportDesign/5.0-Filters-tab/filter_create_below.png", "formatted_filename": "filter create below"}, null, {"document_url": "http://wiki.izenda.us/Guides/ReportDesign/4.0-fields-tab", "unformatted_src": "/Guides/ReportDesign/5.0-Filters-tab/filter_create_above.png", "src": "https://wiki.izenda.us/Guides/ReportDesign/5.0-Filters-tab/filter_create_above.png", "formatted_filename": "filter create above"}, null, {"document_url": "http://wiki.izenda.us/Guides/ReportDesign/4.0-fields-tab", "unformatted_src": "/Guides/ReportDesign/4.0-fields-tab/functions_dropdown_string.png", "src": "https://wiki.izenda.us/Guides/ReportDesign/4.0-fields-tab/functions_dropdown_string.png", "formatted_filename": "functions dropdown string"}, null, {"document_url": "http://wiki.izenda.us/Guides/ReportDesign/4.0-fields-tab", "unformatted_src": "/Guides/ReportDesign/4.0-fields-tab/functions_dropdown_date_time.png", "src": "https://wiki.izenda.us/Guides/ReportDesign/4.0-fields-tab/functions_dropdown_date_time.png", "formatted_filename": "functions dropdown date time"}, null, {"document_url": "http://wiki.izenda.us/Guides/ReportDesign/4.0-fields-tab", "unformatted_src": "/Guides/ReportDesign/4.0-fields-tab/functions_dropdown_numeric.png", "src": "https://wiki.izenda.us/Guides/ReportDesign/4.0-fields-tab/functions_dropdown_numeric.png", "formatted_filename": "functions dropdown numeric"}, null, null, {"document_url": "http://wiki.izenda.us/Guides/ReportDesign/4.0-fields-tab", "unformatted_src": "/Guides/ReportDesign/4.0-fields-tab/pivot-before-after.png", "src": "https://wiki.izenda.us/Guides/ReportDesign/4.0-fields-tab/pivot-before-after.png", "formatted_filename": "pivot before after", "alt_text": "Left: Unpivoted tabular data by country by year. Right: Data by country, pivoted by year"}, null, {"document_url": "http://wiki.izenda.us/Guides/ReportDesign/4.0-fields-tab", "unformatted_src": "/Guides/ReportDesign/4.0-fields-tab/pivot-multi-columns.png", "src": "https://wiki.izenda.us/Guides/ReportDesign/4.0-fields-tab/pivot-multi-columns.png", "formatted_filename": "pivot multi columns", "alt_text": "Multiple columns being displayed in a pivot per year (per pivot column value)"}, null, {"document_url": "http://wiki.izenda.us/Guides/ReportDesign/4.0-fields-tab", "unformatted_src": "/Guides/ReportDesign/4.0-fields-tab/pivot-with-vg.png", "src": "https://wiki.izenda.us/Guides/ReportDesign/4.0-fields-tab/pivot-with-vg.png", "formatted_filename": "pivot with vg", "alt_text": "A pivot being divided by visual grouping"}, null]
4.0 Fields Tab 

The Fields tab is where the actual report is built. This tab allows you to define which fields from your Data Source that will be included in your report and any grouping, sorting, and totaling that needs to be performed. There are a multitude of options that are available to users from this tab. Listed below is a brief description of the properties available on the Fields tab. Next, we will explain a bit more in-depth about each of the controls listed above.

4.1 Field Dropdown Menu

The Field dropdown menu is a list of the available fields in the table(s)/view(s) that are selected on the Data Sources tab. When working with multiple tables/views, the fields are categorized according to which Data Source they come from. The entries in the list that are in Bold are the table/datasource names. If the ShowDatabaseTypes setting is enabled, you could also see the data type next to the field name. 4.2 Description

Automatically inputs the name of the associated Field that you selected. You have the option to change the description and it will appear as the new title when displayed. You may define column groups here instead of on the Advanced Field Options by placing the name of the column group and the at symbol (@) after your field name, for example "Name@Group". You can decide how wide the control is with the DescriptionWidth property.

4.3 Sort, VG, & Arithmetic Check Boxes

The following table explains the Sort, Group, and VG Check Box features.

4.4 Other Buttons on the Fields Tab , and buttons apply to the row that they are displayed in and allow you the flexibility to re-organize your data without creating a whole new report.

4.5 Functions Drop-Down

Functions allow you to perform calculations on the data and can be chosen from the dropdown menu based on the data type of the selected Field. Here is an article on SQL Functions

Note: When calculating a field containing an expression, you must use a function aggregate if you want to use a calculated field in a chart. Click here for more details.

Text (String) Functions Available Date/Time Functions Available Numeric Functions Available Functions Table

4.6 Format Dropdown Menu

The Format dropdown menu is a list of formats for the entries of the field selected in the Field dropdown menu directly to the left to appear in. Depending on the Field data type and the function, you will have differing options for formatting. The main two formats used will be available for all numbers and dates.

Numeric Formats Available

Date/Time Formats Available

4.7 Quick Add

Quick Add lets you add multiple fields to the report at one time by selecting from a list. 4.8 Advanced Field Settings Button

To access the Advanced Field Settings, click on the Gear icon on the selected Field.

For more information: http://wiki.izenda.us/FAQ/advanced-field-settings

4.9 Add Pivot

Add Pivot lets you generate a pivot attached to the right side of the tabular report. This pivot is always on the right side of the fields tab – nothing is further to the right of the pivot. You may add one and only one pivot on the fields tab, meaning that you may have one and only one pivot per report.

The first thing you must do is select the pivot columns. Values in this field will be used to generate the main columns in your pivot. You can thing of this as rotating an entire field 90 degrees, from vertical to horizontal. Left: Unpivoted tabular data by country by year. Right: Data by country, pivoted by year

You must then select at least one column to calculate cell values. These are the values which will be displayed inside of the pivot. You may select more than one column to calculate cell values – each of these will be an independent sub-column generated for each value of your pivot column header. Multiple columns being displayed in a pivot per year (per pivot column value)

While you may only have one pivot, you can graphically break this pivot up by using visual groups. This will also impact the calculation of sub and side totals. A pivot being divided by visual grouping

4.10 Admin Tips

Here are some additional resources that admins can use to increase readability and more precisely define what data users are allowed to view.