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