Hello
I'm tring to graph undrained shear strength results from UU triaxials, pocket penetrometers and shear vanes on one graph for a number of boreholes. I'm plotting against elevation (depth + hole depth).
I have approx 70 shear vane readings, 20 pocket penetrometer and 25 UU's. When I plot them in dependant data 1 -3, I only end up with some of the UU's, a couple of penetromters and no shear vanes.
I can't find the key set or data representation settings to make all the readings display.
Has anyone had this problem? Has anyone found a solution?
Thanks
Try setting the Independent Data Expression to <<ElevFromDepth(<<Depth>>)>>
You need to use <<Depth>> when data comes from multiple tables
set the keyset to PointID,Depth
Phil WadeDatgelBentley Channel Partner and Developer PartnerE: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780
Get the most out of gINT with Datgel Tools.
Thanks for the suggestion. Unfortunately it hasn't helped.
I think that the issue is the keyset and database structure. I'm using AGS 4 format. There isn't a problem when I'm plotting LPEN.LPEN_PPEN and LVAN.LVAN_VNPK against <<depth>>. All results plot.
However, when I add TRIT.TRIT_CU, I only get the lpen's and lvan's that are from trit samples. I think it's because TRIT is a child of TRIG??
I've tried keyset PointID,Depth,Itemkey and it work either.
Under graph data sets I'm using All data items.
Any suggestions?
You need to relate the TRIT data back to the TRIG table, since your graph has a keyset of PointID,Depth.
<<SQL(_ select avg([TRIT].[TRIT_CU]) _ from [TRIT] _ where [PointID] = '<<TRIG.PointID>>' _ and [SAMP_Depth] = <<TRIG.SAMP_Depth>> _ and [SAMP_REF] = '<<TRIG.SAMP_REF>>' _ and [SAMP_TYPE] = '<<TRIG.SAMP_TYPE>>' _ and [SAMP_ID] = '<<TRIG.SAMP_ID>>' _ and [Depth] = <<TRIG.Depth>> _ and [SPEC_REF] = '<<TRIG.SPEC_REF>>' _)>>
This will plot an average of su values for all stages for the specimen.
Works great, thanks.