Build an Indicator Table list

1742
4
Jump to solution
09-29-2023 05:56 PM
susic
by
Emerging Contributor

I am new to Experience builder.  I am attempting to display a table of Counts from a Feature Layer similar to the Photo Attached.  Basically  I want to look at the Data and give a Total Count of the Items that meet those Types.  How do I build a table that dynamically changes base on the inputs to the layer?

0 Kudos
1 Solution

Accepted Solutions
Shen_Zhang
Esri Contributor

Experience Builder does not provide a statistics function in the Table widget. There are couple of walkarounds that may help achieve the function:

1. Add a Chart widget to calculate the statistics. Use the chart output data as the data source of the table sheets.

  • Add a chart and select Statistics as Count
  • Create a new sheet in the Table widget, and select Chart statistics output view

Screenshot 2023-10-07 at 17.48.28.png

Screenshot 2023-10-07 at 17.47.31.png

It will give you a table of counts from selected categories in the Chart widget. But the field name cannot be customized and it can only show one field count in each sheet.  

2. Create data views with predefined filters and use Dynamic content in the Text widget. 

  • Go to the data you would like to calculate statistics and create separate data viewsScreenshot 2023-10-07 at 17.58.28.png
  • Add Text widgets and connect to the data views

 Screenshot 2023-10-07 at 18.00.09.png

  • Use Dynamic content to calculate the count

Screenshot 2023-10-07 at 18.01.09.png

To make the layout pretty, you can use layout widgets like Card, Row/Column/Grid to organize your titles and count texts. Here is an example that I created using Row/Column widgets to organize the layout:

Screenshot 2023-10-07 at 18.11.04.png

Shen Zhang

View solution in original post

4 Replies
sondickerson
Occasional Contributor

Sounds like you might be able to do it with a Data Expression which is a great way to present summarized data.  However, I don't know if the table component in a EB application has the option to use a Data Expression source.  The dashboards do.  Here's a link that will give you more insight:

Introducing Data Expressions in ArcGIS Dashboards (esri.com)

0 Kudos
Shen_Zhang
Esri Contributor

Experience Builder does not provide a statistics function in the Table widget. There are couple of walkarounds that may help achieve the function:

1. Add a Chart widget to calculate the statistics. Use the chart output data as the data source of the table sheets.

  • Add a chart and select Statistics as Count
  • Create a new sheet in the Table widget, and select Chart statistics output view

Screenshot 2023-10-07 at 17.48.28.png

Screenshot 2023-10-07 at 17.47.31.png

It will give you a table of counts from selected categories in the Chart widget. But the field name cannot be customized and it can only show one field count in each sheet.  

2. Create data views with predefined filters and use Dynamic content in the Text widget. 

  • Go to the data you would like to calculate statistics and create separate data viewsScreenshot 2023-10-07 at 17.58.28.png
  • Add Text widgets and connect to the data views

 Screenshot 2023-10-07 at 18.00.09.png

  • Use Dynamic content to calculate the count

Screenshot 2023-10-07 at 18.01.09.png

To make the layout pretty, you can use layout widgets like Card, Row/Column/Grid to organize your titles and count texts. Here is an example that I created using Row/Column widgets to organize the layout:

Screenshot 2023-10-07 at 18.11.04.png

Shen Zhang
susic
by
Emerging Contributor

Thanks, Number 2 seems to be a great option.  Just to confirm, I would need 21 Views to accomplish the below chart.

susic_0-1696695004470.png

 

0 Kudos
Shen_Zhang
Esri Contributor

Based on the provided table, each value necessitates a view, resulting in a total of 21 views. Additionally, creating data views while connecting data can save time as it eliminates the need to do so in advance on the Data tab.

Screenshot 2023-10-08 at 09.50.51.png

Shen Zhang
0 Kudos