SHOW PLOT DO NOT SHOW PLOT

HI,

could anyone either show me the steps or perhaps show the video explaining the following - if it possible at all actually.

What I do not get yet is how to show and hide a plot when the conditions are met or not.
(example) Plot a moving average ONLY IF i.e. today’s low is lower than both yesterdays and the 2 days ago. If it is not then plot nothing. Which function do I need to use for that ? I tried around w/ the IF and SWITCH function but got nowhere.

Thanks
Axel

Hi,

I found one post topic that partially asnwers my quest:

https://forum.optuma.com/topic/show-plot/
(messages 44703 and #44707)

I could indeed play with colors if the conditions are met. For example if today’s LOW() is lower than say the lows of the last 2 days then use Red, if not then use i.e. the background colour. (=not visible). But this is not a very elegant solution imho .

To reformulate my original post in a more different way: Is there no function to only plot when the conditions are met ? (partial plots)

Thanks
Axel

Hi Axel,

Unfortunately this isn’t possible as a Show Plot line has to display a value, so the only option is to change the colour if you would like to see partial plots. A Show Bar or Show View will only show when a condition is true.

Thank you for your reply Darren.

Reason why I thought it could be is the start date function. It could have implied that there is stop date too. Anyway, I will work with the colour changes.

A good week to you all ,
Axel

Hi Darren,

what about something like an ‘invisible’ colour instead?

Just a thought,
Axel

Hi,

This can be done (credit to Darren for assistance). This formula will hide the Show Plot where the result condition is not met (i.e. Zero).

D1=BARDATE()>=STRDATE(DATE=2023/10/01);
V1=DATAFIELD(FEED=XL, FIELD=Wavy PL Open.Stop $, LATESTONLY=True);
If(DATAFIELD(FEED=XL, FIELD=Wavy PL Open.Stop $, LATESTONLY=True)>0, IF(IF(D1,V1,HIDDEN())), HIDDEN())

Note that in the properties, ‘Use Start Date’ needs to be disabled.