Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have all values in YTD for every month ,i.e . Jan YTD 2022 include data from 01/01/2022 to 31/01/2022
feb YTD include data from 01/01/2022 to 28/02/2022 and mar include data from 01/01/2022 to 31/03/2022
but need to represent this Line chart MTD data where month -year i.e. Jan-21 is x axis
In order to represent in textbox ,I subtract current month YTD to last month YTD for example for
Feb MTD= YTD feb- YTD Jan
i.e. 16-10= 6
I am facing difficulty to implement the same in line chart
Hi Priyanka08,
I would prepare my data in the script in order to have it ready to be plotted. To substract current month to the previous one, i would order my table by Month Asc then use PREVIOUS(). Here's a sample :
YTD : Load * Inline [ MONTH, YTD1, 1002, 1503, 3404, 5005, 6006, 7507, 9658, 10009, 114510, 164711, 180012, 2000];MTD : NoConcatenate Load *, if(isnull(Previous(YTD)), YTD,YTD - Previous(YTD)) as MTD Resident YTD;DROP Table YTD;
Regards,
Zouhair