Forecasts don't show up as dotted?

[#1]

Hi, I added a linear trendline to my expression, but the part that is forecasted is a solid line, when I want it to be dotted.  Any suggestions?

[johnca]

I know of no way to format trendlines other than line width (on presentation tab). There may be a method of calculating it using another expression and formatting that.

[#3]

Hi.

See the image to change the line style.

Alessandro Furtado

[johnca]

Yes, but that is a main data expression. What about a trendline?

[#5]

You are correct. I don't know how to change, but using your idea to create another expression maybe solve the problem changing line style.

Alessandro Furtado

[mphekin12]

Under the expression, in the Line Style section you could use an IF statment like:

IF(MAX(WEEK([Session Start]))>WEEK(Today())-2,'<s2>','<s1>')

<s1> is a solid line

<s2> is a dotted line

I hope this helps.

[Anonymous]

Hi,

    Can you please provide a test application ,i will give a answer for that one,

other wise in line style you can add '<S2>' or '<S3>' you will get doted line.

Regards

[vgutkovsky]

I'm sure you've found an alternate solution by now, but I wanted to post this here in case it helps anyone in the future: http://www.infinityinsight.com/blog/?p=295

Regards,

Vlad