topic Re: Column Chart with max bar in Dashboards & Analytics Discussions

Column Chart with max bar

mukulranjan — Mon, 16 May 2022 16:24:53 GMT

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.

Re: Column Chart with max bar

LayeredDelay — Mon, 16 May 2022 19:44:30 GMT

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.

Re: Column Chart with max bar

mukulranjan — Tue, 17 May 2022 13:48:41 GMT

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

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