Line start position in Combo chart

[maxsheva]

Hi,

How can I change a line start position in combo?

Now I have this view

But I need this one where each new point value of line starts from the beginning of next bar.

[sergio0592]

Not sure, it's possible.

[vinieme12]

That line is simply connecting data points ... so if you want to start at 20 change the value of your data point for sum(Plan) for E-commerce to 20 which seems to be around 50!

but would that be correct??

[sunny_talwar]

This might be the closest you might be able to get...

[maxsheva]

Thank you for this variant. It can be used.

Let's imagine some additional 'Channel-A' with no value for this time.

When I put this '1' Bar 'Channel-A' will be shown in dimension with no value.

[sunny_talwar]

you can change the expression for 1 to be like this:

If(sum(plan) > 0 and sum(fact) > 0, 1)

I don't have access to my computer, but the idea is to force 1 to 0 when sum of fact and Sum of plan is 0

[sunny_talwar · Accepted solution]

Image and sample attached