Reference lines are broken on week-based axes

[magnew]

Description

Reference lines are broken on week-based axes

Steps to Reproduce the Bug or Issue

Create a chart with a WEEK data type on one axis. Try to add a reference line.

version

No response

Cloud or self-hosting

None

[magnew]

This is caused be the fact that we moved weeks to use a categorical axis. We suspected there would be some tradeoffs and this is the most painful tradeoff we've seen. Reference lines can't be added to any value on a categorical axis, then have to line up with a category. So you can have a reference line that corresponds with week-start, but not Wednesday, for example. A couple of options here:

• Keep the limitation that lines can only be on weeks, but make it more clear
• Use a numeric axis when there is a reference line is added. This will be a little weird with the labels changing.
• Try using a separate axis for the reference lines and hide everything but the line. This might work, might not. And might be very hard to get right.
• Go back to the drawing board with trying to customize numeric axes in such a way that we can get the labels we want and keep the lines.