Colour Markers on Line Chart

NateBI

Hi Folks,

We are able to use conditions to highlight an entire row in a table using colour rules, but how do we achieve this when we want to highlight specific markers in a line chart - using the same conditional logic?

I'm building an SPC chart from scratch to include more control lines - the controls are conditional columns written in the ETL. At the moment I'm having to bring in the column (control) as a new line in parallel to the main line. This aligns with any points that fall above the average for example. However, I want the markers of the main line to be highlighted similar to how the entire row would be highlighted on a table - without having to bring in the control.

This relates to my feature suggestion here:

Dynamic Colour Rules | Line Chart Markers

NateBI

Jun 23, 2023

The ability to reference a beast mode when setting colour rules so we can create line charts where the markers/line colours dynamically change based on a configured metric comparison.

For example,

Colour for [Field One] when < then [Variable/Beast mode One] | Red

---

View Post

All responses appreciated

Kind regards,

NateBI

Update:
Workaround for this is to overlay the conditional field. To do this, I inputted the main line metric as the output of the condition CASE WHEN [insert logic] THEN [Main Metric] ELSE NULL

Not pretty but closer to the look & feel I want.