line appears in chart, when set to continuous chart.

[#1]

hi guys, 'simple' question. This straight line appears when I set my graph to continuous in the axes tab. Why is this, and what is this line? I have not found a way to turn it off.

I have one expression, I have not set any average line or horizontal reference lines.

expr:

Sum({<operator={'AAA'}>} aggr(Sum(total_hours/60*resource_quantity),ac_registr,TaskPerfDay,TaskPerfMonth))

Dimension:  TaskPerfWeek

ideas?

[crusader_ · Accepted solution]

Hi,

This line appears because of your data, especially dimension.

Your first (1) or last (52-53) week belongs to two months Dec and Jan.

Add year to make it different.

Hope this helps you.

Regards,

Andrei

[#3]

Ye I think it has to do with that

[#4]

Where would you suggest I add year. I tried it in the dimension and expresion. But its still like this. I know the problem now, but the solution has not worked yet.

[crusader_]

Hi,

Hm... try to change your expression a bit:

Sum({<operator={'AAA'}>} aggr(Sum(total_hours/60*resource_quantity),ac_registr,TaskPerfDay))

Hope this helps you.

Regards,

Andrei

[#6]

That does not seem to work either. The line only disappears when I change my dimension from TaskPerfWeek to something else.

Obviously because it has to do with the Week numbering. But how can I manipulate the dimension then? I still want the axis X to be in weeks.

[crusader_]

Why do you use "Continious" checkbox?

PFA, perhaps it helps you to find solution.

Regards,

Andrei