Consolidate tables in dashboard

CorryneVincent — Wed, 01 Jun 2022 17:12:43 GMT

Is their a way to create a table that consolidate and sum the data from two other tables? We'd like to be able to visualize it in dashboard.

Per exemple, my two initials tables would be:

Table 1

name1	quantity
Alex	2
Julia	4
Sylvie	6

Table2

name2	quantity
Julia	4
Alex	3
Tom	2

And the result after consolidation would be:

name	quantity
Alex	5
Julia	8
Sylvie	6
Tom	2

So far, I'm just able to create the initials tables by using name1 as category field in table 1 and using name2 as category field in table 2 while using a count fonction for the second column in both tables.

Thank you for your help!

topic Consolidate tables in dashboard in ArcGIS Dashboards Questions

Consolidate tables in dashboard