I am trying to make a candle stick chart of sorts with high and low daily prices. The problem is writing the expression equation. There are three columns of of interest in the table: Date; TYP; PX. Whenever TYP column is 7 the price for that day is the high price. Whenever TYP is 8 the price for that day is the low price. I am using the date as the dimension. There are no missing values so for the top of the chart I was using:
