topic Re: Combo Chart values displaying incorrectly in App Development

Combo Chart values displaying incorrectly

DanielleW1 — Wed, 01 Mar 2023 16:00:47 GMT

Hi all,

I am having an issue with the data values on a combo chart displaying on top of each other.

The chart consists of bars and lines, but some data points are falling at a similar value, meaning the values are displaying overlapping.

Has anybody any ideas how to get around this issue?

Thanks

Settings are as below:

Re: Combo Chart values displaying incorrectly

sergio0592 — Thu, 02 Mar 2023 14:30:10 GMT

Hi,

You can use dual() function for create a lag with your date point values.With Space ASCII or return carriage ASCII. eg

=dual(chr(32)&chr(32)&sum(Sales),sum(Sales))

Re: Combo Chart values displaying incorrectly

DanielleW1 — Thu, 02 Mar 2023 14:47:13 GMT

Thanks for the response.

I'm afraid this doesn't change the labels which are displayed on the chart when I do this.

The text still sits in the same place even when added spaces or return carriages to the expression

Re: Combo Chart values displaying incorrectly

sergio0592 — Thu, 02 Mar 2023 14:53:57 GMT

It works in QV. Maybe different behaviour on Sense.

Re: Combo Chart values displaying incorrectly

Or — Thu, 02 Mar 2023 14:55:44 GMT

Probably not the response you're looking for, but from a visualization perspective, it's not a great idea to have multiple values on a chart in the first place. If you strictly need the numeric values to be displayed, consider using a table or pivot table (possibly with mini charts included for a visual perspective) instead.