This topic covers tools and techniques for analysing data and trends in JunoViewer Web
Handing No Data in Join Results - Level 2
|
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 uses only those Join Results found on the same Section, regardless of lane. The Level 2 No Data rule is automatically applied for any segment where the Level 1 rule did not yield any result (i.e. still no data found).
The image below shows a Level 2 No Data Rule which specifies that, for segments with No Data, the Mean Value on available join results on the same section 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, all 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 there is no data available on any segments on Section A Lane 2, the Level 1 No Data rule will not yield any results, and thus we drop through to the Level 2 rule.
The Level 2 No Data rule says "use the Mean Value of any join segments on the same section regardless of Lane". Thus we calculate the Mean Value of the join results using those segments on the same section. In this example, this means we take the average of all values on lane L1, which give a value of 8.02. Thus all missing values on Section A are set to the calculated value of 8.02, as shown in the highlighted cells on the right side of the figure above.
If none of the segments on Section A have valid data, then the No Data algorithm will automatically fall through to the Level 3 No Data rule.
edited by admin on 10/11/2015
edited by admin on 10/11/2015
|
|
|
0
link
|
