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.
edit: this is actually the right hand side of the table.The left hand side of the main table - just to show the nature of it. Can be multiple entries for each block.The 'block' column here is linked to the area/block column in the main table.Here is the part that shows area/block - this is the column that links to the 'block' column in the coordinates sheet.This is the visualisation and where each entry comes from - I have tried various combinations. The most succesful one managed to show a separate number for the site and the block, but then drilling down into the blocks placed them all in the same (average) location.
Sorry if this is a bit confusing to understand, not sure how else to display it!
Thanks,
Dan
Resolver IIIOh - ok. That helps me understand.
In Location, you appear to have Area/Block from the Processed Jobs table. Try replacing that with the Block field from the Coordinates table.
When I swapped this, it allowed me to drill-down into the individual blocks, but the blocks all kept the same 'count' as the overall site.
View of all blocks (size relative to count of entries of each block contained within the site)Drilling down into the site - all blocks retain the same count as the overall site.
Any ideas? The count is still of blocks, from the main table of entries.
SeanCommunity Champion
Well the count at the block level for each block is 1.
The Maple Bank Site has a count of 11 - the size of the Site Buble is 11 (at least from I see on the picture you posted)
when you drill down you'll see the 11 Blocks and the count is 1 at each so the size is 1 for all
How do you want to determine their size?
Thanks for the reply Sean.
The size needs to be determined by the amount of total job entries in the table of total jobs (processed jobs) for that specific area.
For example, if Maple bank block 1 had 5 reported jobs, and Maple bank block 2 had 7 reported jobs. The overall area of maple bank (before drilling down) should show a bubble of size 12, and the two Maple Bank blocks should be a bubble relative to the count of jobs there.
At the minute, each block in maple bank is just taking on the total for the whole of maple bank, instead of having separate ones.
The drill down works with this set up (block taken from coordinates table), however each individual block takes on the same count as the site that it belongs to.The location drill down doesn't work with this set-up (block area from the processed jobs table), but each bubble shows the correct size.
So as you can see from both of the drill-downs, currently I can only have one or the other, from correct bubble sizes to correct map placement.