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.

  • Hi PHS,

    There is a how to guide called datamarker override expression that describes almost exactly what you are trying to do. This how to guide is based on a graph report and describes how to override the color of the datamarker but the expression would be the same for datamarker override with some minor modifications. I am attaching the guide. Let me know if this is what you were looking for.

  • 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

  • Sure I wil contact you privately to discuss and look at your specific files. Since both the database and the library are user defineable it would be best to look at your specific files. I will contact you shortly