Scatter Plot - Add dynamic reference lines

Zack Wilson shared this question 12 days ago
In Progress

Hello!


Is there a way to accomplish the task of adding dynamic (item specific) reference lines to a scatter plot? The dynamic portion is currently a calculated field.


/74383e9a70486eeb8d774082cf78209c


Thanks,

Zack

Comments (3)

photo
1

Hi Zack,

Thanks for reaching out to us on this and apologies for the delay. I think there will be a way to do this, but I will need to do some testing tomorrow and come back to you with what I can find.

Cheers,

Neal

photo
1

Hi Zack,

Thank you for your patience. So I have tracked down an existing enhancement request (found here) which is to allow reference lines to be tied to column values in the report which would give you the ability to create a calculated field with the percentage value. I have added you to this request so you can be notified on any progress with this.

In the meantime, to get a close approximation to what you are looking for (as long as I have understood correctly, and it is a little hacky), I have set my scatter plot with a specific width and height, ensured the Scale on the vertical axis is set to Auto and created a second chart (purely for the purpose of accessing the display Canvas). From there on the design page, I have added my scatter chart and two Line widgets around the points I require them. This then allows the chart to change but the reference lines to remain in the same physical location. The images below show what I mean, even when the scale changes the lines remain relative:

/8211bc4e2a3029990d48f315061114c4

/38809c3323a3561793d46e1818ed703c

Please let me know if that is at all helpful, otherwise I will keep you updated on the other ticket for the enhancement request.

Cheers,

Neal

photo
1

Neal,

Thank you for looking into this and adding me to the list! I am not sure that the static lines will work exactly how I need them to as they will not move the same war for each option. However, I do look forward to future improvements!


Thanks,

Zack