Show most recent plotted value

[wendytham]

Hi,

For red line, i am able to show the last plotted value,

but for blue line, the same expression used but the value didn't show up.

Red Line: if(Month = 'Oct', sum ({<FY ={'FY2018'} >}Job)/Sum ({<FY ={'FY2018'} >}Sales), '')

Blue Line: if (Month = 'Mar', sum ({<FY ={'FY2017'} >}Job)/Sum ({<FY ={'FY2017} >}Sales), '')

I have exported the data in excel to check, the point for blue line is calculated correctly, but nothing is shown.

Please assist.

Thank you.

[Sergey_Shuklin]

Hello, Wendy!

Check the single quote here:

Blue Line: if (Month = 'Mar', sum ({<FY ={'FY2017'} >}Job)/Sum ({<FY ={'FY2017'} >}Sales), '')

[ramasaisaksoft]

Hi Tham,

you missed single quote symbol ' in the expression after the 2017',

so it need to be like below

Blue Line: if (Month = 'Mar', sum ({<FY ={'FY2017'} >}Job)/Sum ({<FY ={'FY2017'} >}Sales), '')

[wendytham]

Hi,

Sorry, it's typo.

In QV, the expression is correct. There is double quote symbol.

[Frank_Hartmann]

I guess its because you are not showing Mar-2017 but Mar-2019 in the chart.

[sunilkumarqv]

Have you tried selecting the Year FY = 2017 and see if plot value shows up otherwise try to change the calender dynamically

Blue Line: if (Month = 'Mar', sum ({<FY ={'FY2017'} >}Job)/Sum ({<FY ={'FY2017'} >}Sales), '')