This topic covers tools and techniques for analysing data and trends in JunoViewer Web
Handing No Data in Join Results - Level 1
|
Fritz Jooste Administrator Posts: 81
10/11/2015
|
Fritz JoosteAdministrator Posts: 81
When you perform a Data Join and fold the results into an existing FWP, JunoViewer gives you an option to assign values to segments in your FWP for which there is no data available. The logic for filling in such missing data provides for three levels. The first level is the most sophisticated, and looks for Join Result data on the same section and lane. Using such data (if any is found) a specified statistic is then calculated using the available join data on the same section and lane, and this statistic value is assigned to all segments with the "No Data" flag (indicating that the Data Join could not find any data on that segment).
The image below shows a Level 1 No Data Rule which specifies that, for segments with No Data, the Mean Value on available join results on the same section and lane should be used:
The figure below shows how this Level 1 No Data Rule will be applied by JunoViewer for a Join Parameter called "Rut_80th" (representing the 80th percentile Rut Depth on each join segment):
In this figure, you can see that lane L1 has data on all segments for Section A (sectionID = 1). However, some segments of lane L2 have no data available, and thus the Join Results put a No Data flag on these segments (highlighted in yellow). Since the Level 1 No Data rule says "use the Mean Value of any join segments on the same section and lane", we calculate the Mean Value of the join results using only those segments on the same section and lane. In this example, this means we take the average of 7.2 and 4.3 (available values on lane L2 on Section A, shown in red). The average is 5.75, and is filled into the cells on this section where the No Data flag is found.
If none of the segments on Section A Lane 2 have valid data, then the No Data algorithm will automatically fall through to the Level 2 No Data rule.
edited by admin on 10/11/2015
edited by admin on 10/11/2015
edited by admin on 10/11/2015
edited by admin on 10/11/2015
|
|
|
0
link
|
