suppressing data in "plot vd depth"

I have a plot vs depth for shear strength and would like to include the correlation to shear strength from an SPT N-value. Is there a way to suppress the result if say the lithology symbol/classification = or("XX", "YY", ...)? or some similar expression?

  • The post here has a duscusion on how to do this. It offers 5 different methods and discusses advantages and disadvantages.

    communities.bentley.com/.../dependant-columns-in-log-template

    If you only have one column and not a lot if data you can simply place an expression in the suppress body data output property  similar to

    <<Calc(_

      <<lithology.symbol>> In ("xx","yy","zz")_

    )>>

    I do not have gINT available to me right now so have not tested the above. I am sure I don't have the syntax right but basically all you need is an expression that evaluates to true for the condition that you want to suppress.

    I can provide more info and an example in a few days if you want. In that case it would be helpful if you provided a specific example including a sample output, a picture of the data used to generate it and any relevant data tables, and a picture of the entity tab you want to modify. 

  • Thank you for your response. First i will start with a few examples of what i have tried so far. Everything has been attempted within the "output condition" section of the plot vs depth properties:

    1)

    <<IIf( _
    <<Lithology.Depth>> >= <<SAMPLE.Depth>> And <<SAMPLE.Depth>> >= <<Lithology.Bottom DEPTH>> And _
    <<LITHOLOGY.CLASSIFICATION>> = "CL" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "CH" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "CLS" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "Pt" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "OH", True, False _
    )>>

    2)

    <<IIf( _
    <<Calc( <<Lithology.Depth>> >= <<SAMPLE.Depth>> )>> And <<Calc(<<SAMPLE.Depth>> >= <<Lithology.Bottom DEPTH>> )>> And _
    <<LITHOLOGY.CLASSIFICATION>> = "CL" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "CH" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "CLS" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "Pt" Or _
    <<LITHOLOGY.CLASSIFICATION>> = "OH", True, False _
    )>>

    3)

    <<IIf(<<LITHOLOGY.CLASSIFICATION>> = "CL" Or "CH" Or "CLS" Or "Pt" Or "OH", True, False )>>

    So far either nothing plots or everything plots. Below you will see a screenshot of the report with all the data (nothing suppressed):

    the image quality is bad, but the third plot is the SPT N-value versus depth. on the second plot i have included a crude estimate of the shear strength based on the N-value, however, i wish to only include this estimate if the strata is cohesive ("CL" Or "CH" Or "CLS" Or "Pt" Or "OH", etc.).

    The simplest thing i can think of is to check the lithology at that depth. so for example, in the plot above, i would like to suppress the "shear strength" estimate from the N-value for the first and third layers (MLS and SM).

    hope this helps, and that i made my question a bit clearer. Please let me know if you need any additional information.

  • I just want to add, that i did read the linked post and tried some of the SQLRange() options and other methods, but could not get it to work.

    I also noticed one of my conditional statements in the post above may have an error when checking the depth, but i have fixed that, and still cannot obtain the outputs i am trying to achieve.

  • Could you post a screen grab of the main tab of the plot entity. I suspect it is not working because the plot depth is from a different table than the table with the criteria. I had tried to add this caveat but apparently it didnt post. 

    Not a problem, it just means that you have to use an SQL function to look up the pertinent data from the lithology table based on the current plot depth. SQL functions can be tricky cause you gave to use a mixture of gINT syntax and SQL syntax. I will post an example if you can get me the main tab. 

  • Attached is a screenshot of the different items being plotted....are you saying it might be easier if i make the "main" plot carry the SPT correlation? (more screenshots below)

    below is the requested screenshot of the main tab of the plot entity (last plot entity in previous screenshot):

    Again, let me know if you need anything else, and thank you.