I would like to turn the line on my line chart into a dotted line from a constant one just for the most recent period. Right now my dimension is a cyclic group called MonthWeekDay which includes fields for Month, Week ending and Dates.
So far I have added expressions into text objects to break a part my expression but I am having a hard time pulling it all together when creating the expression under 'Line Style.'
This is what I have broken it down to so far:
=if(max(Month), '<S3>' , '<S1>')
=GetCurrentField(MonthWeekDay)
Can someone please help me put this together into an expression that would work?
Thanks!