u/AbsurdlyGoodBloke

Hi everyone

As title suggests I have an issue with a map visual in creating in UK. (This is a Europe wide map and UK is the only place in having this issue)

The premise: I have a UK map visual, I click into the counties, I can see the KPIs of the counties

The problem: I click into Lancashire for eg, it shows there are 1334 account there. I know from source data it should be 565.

When I export data from the county as table I see 463 Lancashire accounts (missing 102) and then accounts from 6 other counties totaling 871. These 871 accounts appear in every single UK county.

What could be going on here?