Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I want to show a line chart into two style solid and dotted both in alternate way.
I tried to achieve same in Line Style property of Expression tab with If condition but it is doing for mentioned condition only.
But I want to make it follow at alternate level without any condition. Is it possible??
Example : Say I am having Year as dimension and Amount as Sales, now through line chart for year 2009-2010, it shud be a solid line then for 2010-2011 it shud be dotted line and so on...
Pls suggest.
Regards,
Balraj
Hi,
In Expressions Tab you can use in Line Style: if(Year=2010,'<S2>')
Sunny,
Two expression means, two different line?
But I want to do it in a single line with a single expression...
You want some like this??
If yes, PFA
Best,
Sunny
Did not think of this method. I think this is the answer you are looking for.
No,
It should be in a alternate way...
As per your Year Dimension, 2010-2011 is a dotted, then it should repeat for 2012-2013 and then 2014-2015 so on...
Try:
if(Year=2010 or Year =2012 or Year= 2014,'<S2>')
try this:
if(Even(Year)=-1,'<S3>')
Works perfectly Federico Velasco. Balraj Ahlawat this gives exactly what you seems to be looking for:
Great job Federico, thanks for showing us this.
Best,
Sunny
@fvelascog72 good work