topic Re: Bar chart | How to plot a point on a bar chart ? in App Development

Bar chart | How to plot a point on a bar chart ?

Kaushik2020 — Thu, 24 Nov 2022 08:59:52 GMT

Hello everyone,

Here in the image - length of bar shows sum of sales per year for a set of customers.

If I want to show a point on this BAR for a single client based on customer selection filter, is it possible ?

Expectation:

When user select customer name from filter pane, the sales for each year should show as a point on these bars. refer example screenshots for reference.

here the bar chart is static and it does not filter based on details selected in the filter pane.

Re: Bar chart | How to plot a point on a bar chart ?

justISO — Fri, 25 Nov 2022 08:45:39 GMT

Hi, it is possible to do this like this: you take 'Combo chart' with year as your dimension and measure for length of bars

Sum({1}sales)

Notice, that {1} are making expression to ignore all filters, so these bars will become static. No you create 'Height of line' with measure

if( GetSelectedCount(customer)=1, Sum(sales) )

On same expression you press 'More properties', choose Marker and set in Primary axis. Create filter and it is done. Only when you choose one customer, its result appear in chart:

Re: Bar chart | How to plot a point on a bar chart ?

Kaushik2020 — Fri, 25 Nov 2022 09:06:54 GMT

thanks for replying. I am using an enterprise edition cloud. I am not able to see more properties.

Re: Bar chart | How to plot a point on a bar chart ?

justISO — Fri, 25 Nov 2022 09:34:22 GMT

What chart are you using? Probably still bar chart, not combo chart, as I suggested.

Re: Bar chart | How to plot a point on a bar chart ?

Kaushik2020 — Fri, 25 Nov 2022 10:36:11 GMT

apologies for not checking the chart type. I had to change it now from Bar to Combo and it worked. It made my Day 🙂 thank you so much.😌

Re: Bar chart | How to plot a point on a bar chart ?

Kaushik2020 — Mon, 05 Dec 2022 08:48:46 GMT

Hello, Just curious , is there any way we can plot similar dots on a BOX Plot ?