This topic covers tools and techniques for analysing data and trends in JunoViewer Web
Handing No Data in Join Results - Level 3
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, the second level is less sophisticated and looks for Join Results on the same section regardless of lane. The thirds level is the least sophisticated and simply assigns a default value 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 3 No Data Rule which specifies that, for segments with No Data, a fixed default value of 1.0 should be used:
The figure below shows how this Level 3 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 none of the segments for Section A (sectionID = 1) have any data for Join Parameter "Rut_80th". Since there is no data available on any lanes of Section A, both the Level 1 and Level 2 No Data Rules will fail to find any results. Because of this, Level 3 will automatically be applied. As shown above, this level simply assigns a fixed default value to all No Data results on this Section. edited by admin on 10/11/2015 edited by admin on 10/11/2015
|
|
0
link
|