ArcGIS Blog

Analytics

ArcGIS Business Analyst

Build tabular infographics and convert classic reports to the new style in ArcGIS Business Analyst Web App

By S David and Cheryl Hagevik

In ArcGIS Business Analyst Web App, tabular infographics are presentation-ready infographic templates displaying modern data tables. You can use tabular infographic styling in the Run infographics interface as well as in the Run reports interface. If you’re interested in using tabular infographic styling in Esri classic reports, click the Try new report style toggle button. For more information, see New report style in ArcGIS Business Analyst Web App

To build your own tabular infographic, start with an existing tabular infographic template, then update its contents to use the preset styling with your own data. You can build a tabular infographic from scratch by adding variables from the data browser or using data from an existing classic report. To add variables using data from an existing classic report, copy the data from the classic report and paste it into the tabular infographic panel.

How can I build a tabular infographic from scratch? 

First, open the infographic builder by clicking the Reports tab and choosing Build infographics. You will need to use an existing tabular infographic as a starting point. Working with an existing tabular template ensures that you’re using the new tabular infographic styling with uniform theming.  We recommend using a tabular template that resembles your existing classic report. For instance, if you’re using a multi-feature table, we recommend using the Crime Summary (Tabular) template as your starting point.  

For example, let’s use the Standard templates tab and enter tabular in the search field. The Retail Demand by Industry (Tabular) template appears. 

Search for tabular templates.
Figure 1: Search for tabular templates.

Hover over the template and click Open. This template will be modified with customized data from the data browser or an existing classic report. It is useful to clear each panel’s contents so that you can use it as a blank template with preset styling. Hover over a table and click Edit to open the editor window 

Open the editor window for a table.
Figure 2: Open the editor window for a table.

In the editor window, clear the contents of the table. Select all of the cells in the table and press the Delete key on your keyboard. Or select all the cells and click the Settings button, click the Modify table tab, and click Clear cells. Click Apply to save the changes.  

Clear the contents in your table template.
Figure 3: Clear the contents in your table template.

Now you have a blank table with the tabular infographic styling. You can continue clearing the contents in the template or start adding new content, such as a new header and footer or variables in the tables. You can add variables starting either from the data browser or from an existing classic report. 

Use your blank table with tabular infographic styling.
Figure 4: Use your blank table with tabular infographic styling.

How do I add variables from the data browser to a custom tabular infographic? 

One method to customize the data is to choose your own variables using the data browser. 

Use the tabular template that you created. Hover over the panel and click Edit to open the editor window. Add variables to the table from the data browser and drag them to the table. The table will automatically populate with the variable value and name.  

Add variables to your table using the data browser.
Figure 5: Add variables to your table using the data browser.

Continue to modify your table with customized headings and any additional variables that you need. Click Apply to implement the changes. You can repeat the process by adding more tables and customizing the variables selected.  

How do I convert an existing classic report to a tabular infographic? 

You may have existing classic reports that you want to convert to tabular infographics. You can select the content from your classic report, copy the variables, and paste them into your blank tabular infographic template. 

Start with the tabular template that you created. Then, go to your custom classic report template by clicking Build reports on the Reports tab. Click Get started for the first option Build a report from an existing report or from sections of existing reports. Select one of your custom reports and drag the report sections that you want to use from the existing report into the report template. Alternatively, you can add the full report by clicking + Add full report.

Drag report sections to template
Figure 6: Browse your classic reports and select data.

Return to the blank template that you created with a tabular infographic panel as a style reference by clicking Build infographics on the Build reports tab. Hover over the table, and click Edit. In the editor window, click Table properties. Modify the panel with the number of rows and columns to match the table in the classic report. Click Apply to implement these changes. 

Modify the table properties
Figure 7: Modify the size of the tabular infographic table.

Since you started with the existing tabular template, styles for table theming are automatically applied. To check the styling of the table, highlight a cell (or cells), click the Edit button, and select the Style cell tab. Using the Styles drop-down menu, the tabular styling is: 

  • Table header style for top row 
  • Default style for unshaded rows 
  • Alternating row style for shaded rows  
Check the styling of the tabular infographic table.
Figure 8: Check the styling of the tabular infographic table.

Return to the classic report by clicking Build reports on the Build reports tab. Click the Edit in the report section, and highlight the data that you want to copy. Click the Edit button to open the settings, and click the Modify table tab. Click the Copy cells drop-down menu and select Variables and other content. The values and names of the variables are copied to your clipboard. 

Copy the variables and other content from the classic report
Figure 9: Copy variables from your custom classic report.

Navigate back to the infographic template by clicking Build infographics on the Build reports tab. Hover over the table and click Edit. In the editor window, highlight the cells in the table. Click the Edit button to open the settings, and click the Modify table tab. Click Paste cells to paste the variable names and values from the classic report into the table. Click Apply to implement the changes. 

Paste the cells into the infographic table
Figure 10: Paste your classic report data into the tabular infographic table.

Now you have data from the classic report in the tabular infographic formatting. You can repeat the process by adding more tables and copying data from classic reports.  

Example of classic report data in the tabular infographic formatting
Figure 11: The tabular infographic table is updated with data from an existing classic report.

How can I modify the template? 

You can modify your template for both design and content. We’ve covered how to add data from the data browser or an existing classic report above. In terms of customizing the design, there are endless customizations that you can make. Some customization options include: 

  • To change the theming for the entire tabular infographic, click Theme and click Advanced options. Use the Table settings to select your preferred color scheme and fonts, and click Apply. The new settings are applied to the entire tabular infographic.
Workflow of changing the theming in a tabular infographic
Figure 12: Change the theming of your template.
  • To add your logo, hover over the existing Esri logo and click Delete. Then you will work with images as usual, by clicking Add element and clicking Logo. The logo that you set in your app preferences will appear. 
  • To edit a table, hover over a table and click Edit. Modify the table as usual by changing the variable selection, the font and font size, and background color.   

This article has introduced you to creating custom tabular infographics. It described how to create a custom template, how to add variables from the data browser, and how to add data using an existing classic report. These workflows are flexible and can be customized. It is recommended that you save the custom template you created to have a ready-to-use style reference. You can also create a custom tabular infographic using existing tables from the tabular infographics in the gallery and configure them to your preference. Please use the feedback option at the bottom of this blog article or post on Esri Community. 

Share this article

Subscribe
Notify of
0 Comments
Oldest
Newest
Inline Feedbacks
View all comments