Line chart expression

[#1]

Hi all,

i'm trying below expression in Line Chart. I,m calculating the Cloverunit = A06129, Lens#=1, measure=Ave Lens Diameter(mm), PLDate = last 2 months sum of LCL.

In pivot table having another few more expressions that displays data from all the dates(Not restricted to last two months).

=Sum({1<[Clover Unit]={'A06129'}, Lens#={'1'},measure={'Ave Lens Diameter (mm)'},PLDate={">$(=Date(AddMonths(Max(PLDate),-2),'MMM DD YYYY'))"}>} LCL)

Now i'm getting line in chart for LCL for last two months , but that value line should display for entire data. Please find the attached screen shot.

Thanks in advance

Regards,

Venkat.

[#2]

Yes,LCL of last two month will be higher.

In the screenshot you shown  the LCL is bending down if it is not in between last two months period. Now if it is not in between period then also it should show the  straight line instead of bending.

Thanks in advance.

[#3 · Accepted solution]

Hi,

Myself found the solution. Here is the attached app what i tried for.

Regards,

Venkat