Muliple dependant data in graphs

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

Parents
  • 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 Wade
    Datgel
    Bentley Channel Partner and Developer Partner
    E: 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?

    Thanks

  • 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.

    Phil Wade
    Datgel
    Bentley Channel Partner and Developer Partner
    E: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780

    Get the most out of gINT with Datgel Tools.

Reply
  • 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.

    Phil Wade
    Datgel
    Bentley Channel Partner and Developer Partner
    E: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780

    Get the most out of gINT with Datgel Tools.

Children