cancel
Showing results for 
Search instead for 
Did you mean: 

Column Chart with max bar

mukulranjan
Rocketeer

How can I build a column or bar chart showing the max line on top of each bar. for example as shown below, the bar graphs are used capacity and line are total available capacity for a storage facility.

mukulranjan_0-1652718247362.png

 

2 REPLIES 2

LayeredDelay
Employee
Employee

This is something that would be relatively easy to build using our Component SDK. But you can do something very similar using the combo chart with scatter as the secondary measure which will place a dot on the chart. See my example here. Hope this helps, if you have any follow up questions @mukulranjan, please let me know. 

Screen Shot 2022-05-16 at 12.03.52 PM.png

mukulranjan
Rocketeer

Thanks for the alternate option, this is the exact solution I have at present but it has a gap. In my current requirement I have 6 measures. 3 separate sets of value and target, linked together with colors (same color for 1 pair of value and target). but if you filter the insight with one set the column and dots do not align, dots come on top of each other instead of on top of column, as below

mukulranjan_0-1652795226207.png

Is there a way I can always keep target dots on top of each column measure?