Line Chart max year and min year behavior

[Barry-Gon]

Hi,

I have a line chart with the given values. The chart works fine with two consecutive years, but

1) When I select 3 years the lower year and the highest year for some reason the values in the line chart have a funny behavior.
2) When I select the lowest and the highest years, the chart only shows the highest year

Correct chart

Three years (Wrong)

Max and Min years selected  (Wrong)

Please help

@rubenmarin  You helped me before, any advice?

Thanks in advance.

[edwin]

You have a pretty complicated expression and its hard to say why it is returning the value it is returning wihout understanding the business rules. 

to help point you to the rt direction, change your chart type to STRAIGHT TABLE you will see that for 2018 the expression is returning 0 for 2018.  thats bec most of the main expressions return 0 for 2018.  find out why its returning 0 and you might solve your problem hence you see just one line

[Barry-Gon]

Thank you  Edwin / Specialist II

The Table works fine, but when I change the view to Line Chart, for some reason the values are not display as the REAL column.

• AmtUSD - Is the full accumulation of the month from the previous month
• DaysOfMonth - Is the full accumulation of the number of dates from the previous month
• Real - The result od divide the value of AmtUSD / DaysOfMonth

I also posted this  Line chart with two dimentions do not display correctly 

Is the same issue.

Any advice?

Thanks

[rubenmarin · Accepted solution]

Hi @Barry-Gon, PFA.

[Barry-Gon]

Thank you very much as always. It works perfect.

Very helpul. 🙂