Forum Discussion
Mapping locations with drill-down into sublocations
Hi danielc7150 - I can get a test to work the way I think you want it to by doing this:
Location
Coordinates [Site]
Coordinates [Block]
Latitude
Average of Coordinates [Latitude]
Longitude
Average of Coordinates [Longitude]
Size
Count of 'Processed Jobs' [Area/Block] <-- note this is from 'Processed Jobs' NOT 'Coordinates. Also, make sure this is set to Count and not Count (Distinct)
I only have one relationship, and that is from Processed Jobs (Area/Block) to Coordinates (Block)
If I set it up like this, the bubbles at the size level are sized based on the total number of 'jobs' for the entire site. When I drill in, the bubbles are sized by the total number of 'jobs' for each block.
Community ChampionCan you post the formula of the Measure you are trying to use?
Resolver IIIHi danielc7150 - I can get a test to work the way I think you want it to by doing this:
Location
Coordinates [Site]
Coordinates [Block]
Latitude
Average of Coordinates [Latitude]
Longitude
Average of Coordinates [Longitude]
Size
Count of 'Processed Jobs' [Area/Block] <-- note this is from 'Processed Jobs' NOT 'Coordinates. Also, make sure this is set to Count and not Count (Distinct)
I only have one relationship, and that is from Processed Jobs (Area/Block) to Coordinates (Block)
If I set it up like this, the bubbles at the size level are sized based on the total number of 'jobs' for the entire site. When I drill in, the bubbles are sized by the total number of 'jobs' for each block.
Many thanks to everyone that contributed!
It seems as though I was missing a relationship between the two 'blocks' entries - one which I thought I had implemented, but apparently did not!
Thanks again!
Dan
