Forum Discussion
Map visual with hours spent/available
Hi, I would like to plot a map to show the total hours spent in each city based on the date selected.
Each technician has 1560 available hours in a year which means 130 hours per month.
How to plot all these information in a map to see the total hours spent and available hours of each technician in the city?
Table A:
| Date | Job# | City | State | Hours Spent |
| 03/01/2020 | A-123 | Douglaston | New York | 7 |
| 10/31/2020 | B-123 | Sparks | Maryland | 13 |
| 03/01/2021 | C-123 | Douglaston | New York | 17 |
Table B:
| Technician | City | State |
| Abby | Douglaston | New York |
| Ben | Sparks | Maryland |
| Charles | Dallas | Texas |
| Don | Rochester | New York |
Add the available hours as a calculated column to your dataset, and then use it for the bubble size of your location data in the map visual
1 Reply
- lbendlin
Super User
Add the available hours as a calculated column to your dataset, and then use it for the bubble size of your location data in the map visual