How to use building attributes in a Combo Overlay
Jump to navigation
Jump to search
Building attributes can be accessed directly in a Combo Overlay by configuring attribute keys. In this how to both a Global as a Building attribute is used to converted a daily average traffic amount to an hourly traffic amount.
How to use building attributes in a Combo Overlay:
- Select Current Situation in the ribbon bar.
- Hover over Overlays and under Grid Calculation, select Average and Interpolation.
- In the Average Overlay Detail Panel, change the Cell Average Distance to 0.
- Select the NUM_CARS attribute
- Select the Attributes tab and change the ATTRIBUTE TIMEFRAMES to 24.
- With the Average Overlay configured, select Current Situation in the ribbon bar.
- Hover over Globals in the ribbon bar and select Add new Global.
- In the Global detail panel, change the name to HOURLY_TRAFFIC_VALUES.
- Set the start values to the following array:
0,12 0,06 0,024 0,048 0,108 0,48 1,32 1,8 1,8 1,44 1,2 1,2 1,44 1,44 1,68 1,92 1,8 1,8 1,32 0,96 0,72 0,6 0,48 0,24
- With the Global configured, select Current Situation in the ribbon bar.
- Hover over Overlays and under Grid Calculation, select Combo Overlay to add a new Combo Overlay
- In the Combo detail panel, select the tab Input
- For Attribute A, select the attribute: NUM_CARS
- Select the general tab.
- For Input A, select the Average Overlay.
- Click on the enlarge link next to Formula to edit the Combo Overlay's formula.
- Write the following formula
IF(OR(A1:23), AT, MUL(GLOBAL_HOURLY_TRAFFIC_FACTOR, @A))
- Close the formula panel.
- Click on update now in the Overlay detail panel.
- Once calculated, inspect the resulting overlay.
Legend used in how-to
The content below can we copied and pasted as a legend for the Average and Combo overlay.
[ { "color" : { "argb" : -1 }, "entryName" : "None", "id" : 1, "value" : 0.0 } , { "color" : { "argb" : -15414180 }, "entryName" : "10", "id" : 2, "value" : 10.0 } , { "color" : { "argb" : -12923884 }, "entryName" : "200", "id" : 3, "value" : 200.0 } , { "color" : { "argb" : -5714924 }, "entryName" : "400", "id" : 4, "value" : 400.0 } , { "color" : { "argb" : -3374828 }, "entryName" : "800", "id" : 5, "value" : 800.0 } , { "color" : { "argb" : -65536 }, "entryName" : "1200", "id" : 6, "value" : 1200.0 } , { "color" : { "argb" : -65281 }, "entryName" : "2500", "id" : 7, "value" : 2500.0 } ]
Notes
- The values provided for the Global are example values and can be adjusted.
- The formula uses an if or statement for the average overlay, such that it selects the Average Overlay' s values if it has a number larger than zero, and select the Combo Overlay Multiplication otherwise. This way roads with multiple num_car values is not adjusted; only roads with a single num cars value are.