Yes, you're correct  it doesn't have data for all the months in the previous years... this index i created with some random dummy data for testing purpose i guess in original data it might be their is a data presence for each and every month for pervious years as well.    ... View more

Above is the output after where clause is removed.   ... View more

index="home2" | bin _time span=1mon | stats sum(AMOUNT) as thismonth by _time | eval finmon=strftime(_time,"%m") | eval previousyear=if(finmon<4,-1,0) | eval finyear=strftime(_time,"%Y") | eval finyear=previousyear+finyear | eventstats sum(thismonth) as financialyear by finyear | eval currentmonth=strftime(now(),"%B") | eval currentmon=strftime(now(),"%m") | eval currentyear=strftime(now(),"%Y") | eval finyear=if(finyear=currentyear,"current","current-".(currentyear-finyear)) | where finmon=currentmon | table finyear thismonth financialyear   Same code yesterday i got results for current, current-1,current-2 but now it displaying only current-2 .......today change in the month happend i mean today is july 1st is that the case?? ... View more

Also only Current-2 data is displaying now in visualization ... View more

if the financial year is starts from july 1st only change in the code is  | eval previousyear=if(finmon<7,-1,0)  Correct??   ... View more

Thank You !!! it's  working  . ... View more

Hi, Is that possible to plot like  Current, current-1 and current-2 instead of 2021,2020 and 2019 on x-axis????? Because we are comparing both Yearly and monthly data over graph right?? ... View more

Great Got it!!!!!!!!! Thank you so much. ... View more

Thank you !!!!!  Really helps a lot.....Query gives us a 90% solution Can you  Please explain a logic behind that "8" below? | eval finmon=(8+finmon)%12 | eval previousyear=if(finmon>8,-1,0)   ... View more

Actual Result i got for query you have shared Excepted Result Thanks !! for the Query. Please find the above attached actual result and excepted results SS and do needful.  ... View more