I need to workout the mean participation value from the data table for the coarser level of governance, what this means is i have multiple values from the finer level that i need to calculate the mean for then link to the coarser level. I've tried using the summary statistics tool on a joined then exported table with casefields but the return seems to be an integer, not a float
Screenshots
Feature layer table, working field is NUTS315CD/NUTS315NM
Link table, Contains NUTS318CD(same codes as the previous table just different naming convention) and finer level of governance codes needed to link to the data table
data table, county is the same as LAD16C from the link table, participation is the data i need to calculate the mean for
merged table that i'm trying to run tools on
Do you have any pointers for tools or scripts?
Solved! Go to Solution.
I'd recommend looking into the issue with the Summary Statistics tool, it is by far the easiest solution. Maybe post that issue.
I'd recommend looking into the issue with the Summary Statistics tool, it is by far the easiest solution. Maybe post that issue.