Map View Help
My app tracks maintenance tasks (similar to the facilities management app).
We have a few buildings around the town and these are shown on the map which the system automatically generated (using the latlong field).
Great but the map is not really useful unless it highlights which buildings have existing jobs attached to them which are still incomplete.
Currently it just shows me all the buildingsโฆ
So I have a slice which shows โIncomplete Jobsโ but I cannot figure out a way to show this slice on the map and have the pins for the data in this slice show in โredโ for instance so that they stand out as buildings with incomplete jobs.
Any ideas?
I think you can make a format rule. So you donโt even need the slice, use the incomplete condition that you used for the slice as a format rule to turn the dot green or redโฆ
FYI @Ben_Derrick if you want to map a slice, change the map view definition to use the slice instead of the table.
@praveen I tried this but my maps shows locations of properties based on their LatLong value.
However, the slice doesnโt include LatLong data just one collumn which references the table including the LatLong dataโฆI am unsure how to link a new row on my main sheet with the LatLong data in another sheet if that makes senseโฆ
@Grant_Stead Indeed I have been attempting exactly that.
However, I have two tables: PROPERTIES (lists the property locations by LatLong value) and MAINTENANCE (lists maintenance jobs and there is a reference column to the Properties table).
If I make a format rule with table โMaintenanceโ the map doesnโt pick up the addresses from the Properties column and shows no pins.
If I make a format rule with table โPropertiesโ the map shows pins of all the properties in the table.
If I put condition as [Status] = โIncompleteโ of course it does not pick up the column โStatusโ as this is in the Maintenance tableโฆ
Iโm missing some connection between the Maintenance and Properties table and I canโt figure out what it is.
Does this make sense guys - I feel like Iโm rambling on.
Let me know if you need more information.
Thanks.
@Ben_Derrick Sounds like you need a helper column of some sort somewhereโฆ I think the easiest would be to put a DE-REF on the Maintenance table where you reach into the properties table, and grab the latlongโฆ Then the LAT LONG of the property is there on the maintenance activity record. Then you can slice the maintenance activities showing only the ones that are incomplete, and you would be able to map the maintenance records because they now have a latlongโฆ
The DE-REF would be appformula: [property ref column].[column in property table with lat long]
Yes!
That worked - thank you!
However, one final thing is really bugging me (this wonโt let me upload pics for some reason otherwise I would send some screenshots).
When viewing the Properties table (and now the map view) and I click on a property to view detail view it includes a system generated column at the bottom called โRelated Maintenance by Propertyโ which shows all the jobs relating to that property from the Maintenance table.
However, as date column is the first column in Maintenance table it shows the date first but I want it to show property first.
I can rearrange column order in the view itself but not this system generated sectionโฆ any ideas?
@Ben_Derrick you should be able to either create a table view position ref ref if that data source, and adjust that, or there might be a system view that you can come by clicking a little button somewhere that says show system views
User | Count |
---|---|
41 | |
28 | |
28 | |
23 | |
13 |