Column and Line Combo Chart on Pivoted Data

[jt]

Is there a way to format this so the lines “stick” to their column?

Left Y-axis = a metric I am tracking

Right Y-axis = that metric as a % of some individualized target

X-axis = date dimension

The three violet columns represent different items I am tracking. I am comparing them against each other every day.

I also want to visualize how each day compares to a specific target for each item. For this I calculated the % and am displaying it as a line. However the lines stack on-top of eachother instead of aligning with their respective columns.

[Black line > Dark violet] [Orange line > Medium violet] [Red line > Light violet]

Note, there are multiple items that can be picked in this dashboard so I need it to dynamically update and not break when a new item is picked.

I am open to displaying this information in a different way such as: https://www.highcharts.com/demo/highcharts/column-placement but haven’t been able to make this work yet either.

The data structure is pivoted by item as sketched below.

I appreciate any thoughts or advice!

[GavinW]

It’s difficult to help with something like this without having it in front of you to play with, so my apologies that I can’t give you direct help on this - but I am wondering if you have tried getting the result you want using a combination of Looker’s Chart Config Editor and the LLM of your choice?

There’s also an article here that details using AI to create an entirely custom visualization.

[jt]

Thank you for your reply @GavinW . I’ve experimented with the Chart Config & Highcharts own LLM & others to no avail. Even the pointPlacement doesn’t seem to work in this instance. It may just be a lack of capability of the software!