Hi,
Has anyone able to plot test results from multiple associated points in a single plot vs. depth column (log) using "Foreign PointID expression"?
can u please suggest any other workaround if the above isn't possible?
TIA
Sapna
Hi Sapna,
Here's an example of a way you can do that.
I added two fields to the Point table to enter associated boreholes:
Then in Report Design, you can have multiple Plot vs. Depth columns that plot in the same column. You will need to adjust the Header Position and Number of Header properties accordingly in the Column tab.
Each Plot vs. Depth entity has the same Data Expression in the Main tab, but a different Foreign Point ID Expression in the Configuration tab. The first "Fines" plot has no Foreign Point ID Expression so that the main BH's data plots.
This worked in some cases (see note of caution below). Each Plot has different colors for the Data Markers and Lines to differentiate the boreholes:
Note of caution: In the example above, the Data Expression was a simple reference to a <<Table.Field>> for the Fines Content:
This worked fine. However, it did not work for more complex expressions. For example, the Data Expression below used in many standard files to obtain Fines Content did not plot successfully. Maybe someone else has a solution to get this to work, but I haven't been successful yet.
If you need to use more complex data expressions to plot data from multiple boreholes, my recommended workaround would be to use a Graph report instead of a Log report.
Jesse
Hi Jesse,
Thank You.