Reference line for a Dimension

[mbespartochnyy]

Hello community,

I'm working on a simple chart that displays seasonal average prices for an index. My dimension is a date field and expression is an average of bid and offer values. I would like to have a reference line on a chart to show when each ear starts.

For example, attached is the sample app with charts that I would like to have. The only addition that I would like to make to the chart is have a vertical reference line showing up on January 3, 2017, January 4, 2016, January 1, 2015 etc.

Does anyone know of a way to get that reference line on the chart?

Thanks in advance,

Mikhail Bespartochnyy

[sunny_talwar · Accepted solution]

The vertical reference line is only possible when you have continuous axis. Will something like this work for you?

[mbespartochnyy]

That's exactly what I was looking for! Thanks, Sunny!

Do you know if there's a way to have the Enable X-Axis Scrollbar working with continuous axis option enabled?

Mikhail B.

[sunny_talwar]

I don't think it is possible, but I can check

[sunny_talwar]

Don't think this is possible

[flipside]

As an alternative to Sunny's suggestion, you could add a second expression like this ...

=if(Deal_Date='1/4/2016',Dual('-----------------------------------------------------------------------------------------------',0.01),'')

... tick the Values On Data Points option and set labels to display vertically (on the Presentation tab). It will only display when there's a reduced number of data points but it might work for you. Bit of a hack, though. And I haven't tested it through Accesspoint either.

I'd also look at options such as setting the line color and line styles to alternate between periods. Also, you could change to a combo chart and have an alternating background color (essentially a static bar value which changes to alternating shades at the require date points - just set the Bar and Cluster distances to zeroes).

flipside

[mbespartochnyy]

Thanks for looking into it, Sunny! I ended up simply enabling the continuous x-axis. Didn't get any complains yet.

[sunny_talwar]

That's awesome