Change Line Color based on Expression based on date dimension
I need to see if I can modify the color of the line in a line chart. I have a dimension which is a date.
I do a calculation of the difference between the Max Date and and average of another field. I want the color of the line to be red prior to this cutoff and green after this cutoff. The calculation is not a measure in my chart and I don't want it displayed.
For example my max date is 43894. I subtract 2 from that and get 43892. So all dates on the line prior to 43892 should be red and 43892 and later should be green.
I hope I explained that ok.
I have tried everything that I can think of and nothing has worked so far.