Override data marker expression - based on geology code

Hi,

I'm having difficulty finding a way of plotting a simple SPT vs depth graph with SPTs from different geology codes plotting as different shapes.

As a basic example I have tried using:

<<Switch(_
  <<Like(<<GEOL.GEOL_GEOL>>,"*G")>>,13,_
)>>

I'd hoped this would return data markers as star shapes for any spt value with a geology code which ends with G (for granular) and default for anything else.  However it only seems to work if the SPT (ISPT.ISPT_TOP) value is the same as the top of the geology code in strata main...

Anyone got any ideas?

PHS.

Parents Reply Children
  • Hi David,

    Thanks for getting back to me.

    Yes I had seen this how to guide, but it didn't really explain the code used so modification for another purpose was difficult.. (and in fact I couldn't make it change the colours when I used it either..)

    <<Case(<<SqlRange(_
    <<Depth>>,_
    [GEOL].[GEOL_GEOL],_
    [GEOL].[GEOL_BASE],_
    [GEOL].[Depth],_
    1_
    )>>,_
    = "A",255,_
    = "B",16711935,_
    = "C",49152,_
    = "D",8421376,_
    )>>

    In this expression why are GEOL.GEOL_BASE and GEOL.Depth included if we're only checking what's in the GEOL_GEOL field?  If this was a personal project I'd be happy to fiddle but I'm supposed to be working !

    Can you explain this code in english so I can get a feel for what it does?  Something like

    First find values of GEOL_GEOL or GEOL_BASE or GEOL depth, then see if they = A or B or C or D then return appropriate colours?  

    Thanks for your help.

    PHS