You can modify a report to change the way the report displays information, or filter the data for different audiences by using the Report Editor.
- If App Studio is not in Preview mode, in the header, click Preview application.
- In the header of App Studio, select the portal in which you manage reports.
- In the left navigation pane, open the Report Browser by clicking Reports.
-
Select the reports that you want to view:
- To view your custom reports, click the My Reports tab.
- To view all available reports, click the All reports tab.
- Click a report to edit.
-
In the upper-right corner, click Edit report, and edit the
report:
Choices Actions Change the report title At the top of the Report Editor, in the text field, enter a new report title. Add a column to the report From the Data Explorer section, drag the column next to an existing report column. Remove a column from the report - Hover over the right side of the column, and then click Open Menu.
- Click Delete.
- In the Delete Column Confirmation modal dialog box, click Submit.
Change the column heading - Hover over the right side of the column, and then click Open Menu.
- Click Heading.
- In the Column heading field, enter the column name, and then click Apply changes.
Format the column values - Hover over the right side of the column, and then click Open Menu.
- Click Format.
- In the Format values field, enter appropriate value, and then click Apply changes.
Sort the column values - Hover over the right side of the column, and then click Open Menu.
- Click Sort.
- If you want to display values in ascending order, click Lowest to highest.
- If you want to display values in descending order, click Highest to lowest.
Add a chart to the Summary or Chart report type - Click Add chart.
- Click All chart types.
- In the Select Chart Type modal dialog box, click a chart type that you want to include in the report.
- Click Submit.
- From the Available columns section, drag the columns into the chart.
- Click Apply changes.
Edit the report chart - If a chart already exists, click Edit chart.
- Click Title to change the chart title.
- Click Color settings to customize the chart colors.
- Click General settings to set general chart settings.
- Click Apply changes.
Filter the columns content - From the Data Explorer section, drag the filter into the Drop column to add Filter box.
-
In the Edit filter section, set filter options, and then
click Apply changes.
For more information about filter conditions, see Editing filter conditions.
Switch between simulated and actual data Depending on your business need, click Actual data or Simulated data.Note: Designing a report with simulated data avoids repeated database queries while you edit the report, allowing for faster changes. - Click Done editing.
- Report Editor
The Report Editor provides tools and resources to help you edit a report. The Report Editor displays the report name, and the time and date of report generation.
- Modifying list reports
Manage the appearance and content of list reports by modifying the column settings in the Report Viewer. For example, you can filter the content to display in columns, sort the data, or adjust column widths to make the most relevant data easier to see.
- Modifying summarized reports
Manage the appearance and contents of summarized reports by modifying the column settings in the Report Viewer. For example, you can specify the format of values, or change the column width.
- Data Explorer
In the Report Editor, the Data Explorer provides an efficient way to find a property or calculation to include as a column in a report. You can also use the Data Explorer to define filter conditions.
- Adding filter conditions
Customize the report to meet the required business needs by displaying only the relevant data.
- Adding or editing charts in the Report Editor
Display a graphical representation of the report data by adding a chart to the report in the Report Editor. The report requires aggregated data to include a chart.
- Removing charts in the Report Editor
Save space by removing redundant charts from the summarized reports in the Report Editor. For example, you can remove a chart if you delete the data that the chart uses.
- Converting a list report to a summarized report
Analyze the numerical data to discover the number of particular events in the application by converting the list report to a summarized report. For example, you can summarize the total number of user identities in the application.
- Converting a summarized report to a list report
Make the report more readable to facilitate the data analysis by displaying the summarized columns in the form of a list.