https://community.splunk.com/t5/Splunk-Search/How-do-you-display-the-last-4-months-in-Splunk-starting-from-the/m-p/431195#M173323 <P>@sbhatnagar88 ,</P> <P>Try</P> <PRE><CODE> |makeresults |eval months=strftime(mvrange(relative_time(_time,"-3mon@mon"),relative_time(_time,"@mon+1"),"1mon"),"%B %Y") |mvexpand months </CODE></PRE> <P>Detailed/expanded version </P> <PRE><CODE>|makeresults |eval earliest=relative_time(_time,"-3mon@mon") |eval latest=relative_time(_time,"@mon+1") |eval months=mvrange(earliest,latest,"1mon") |eval months=strftime(months,"%B %Y") |mvexpand months|table months </CODE></PRE> Tue, 29 Jan 2019 14:23:39 GMT renjith_nair 2019-01-29T14:23:39Z https://community.splunk.com/t5/Splunk-Search/How-do-you-display-the-last-4-months-in-Splunk-starting-from-the/m-p/431194#M173322 <P>How do you display the last 4 months in Splunk starting from the current month?</P> <P>Required output is:</P> <P>January 2019<BR /> December 2018<BR /> November 2018<BR /> October 2018</P> Tue, 29 Jan 2019 11:29:06 GMT https://community.splunk.com/t5/Splunk-Search/How-do-you-display-the-last-4-months-in-Splunk-starting-from-the/m-p/431194#M173322 sbhatnagar88 2019-01-29T11:29:06Z https://community.splunk.com/t5/Splunk-Search/How-do-you-display-the-last-4-months-in-Splunk-starting-from-the/m-p/431195#M173323 <P>@sbhatnagar88 ,</P> <P>Try</P> <PRE><CODE> |makeresults |eval months=strftime(mvrange(relative_time(_time,"-3mon@mon"),relative_time(_time,"@mon+1"),"1mon"),"%B %Y") |mvexpand months </CODE></PRE> <P>Detailed/expanded version </P> <PRE><CODE>|makeresults |eval earliest=relative_time(_time,"-3mon@mon") |eval latest=relative_time(_time,"@mon+1") |eval months=mvrange(earliest,latest,"1mon") |eval months=strftime(months,"%B %Y") |mvexpand months|table months </CODE></PRE> Tue, 29 Jan 2019 14:23:39 GMT https://community.splunk.com/t5/Splunk-Search/How-do-you-display-the-last-4-months-in-Splunk-starting-from-the/m-p/431195#M173323 renjith_nair 2019-01-29T14:23:39Z https://community.splunk.com/t5/Splunk-Search/How-do-you-display-the-last-4-months-in-Splunk-starting-from-the/m-p/431196#M173324 <P>I believe you need to change the maximum amount of results your query can display before you can do this. Unless you're talking about the actual syntax query. </P> <P>Are you talking about the query or about not being able to see 4 months of data? </P> Tue, 29 Jan 2019 14:53:11 GMT https://community.splunk.com/t5/Splunk-Search/How-do-you-display-the-last-4-months-in-Splunk-starting-from-the/m-p/431196#M173324 ryhluc01 2019-01-29T14:53:11Z https://community.splunk.com/t5/Splunk-Search/How-do-you-display-the-last-4-months-in-Splunk-starting-from-the/m-p/431197#M173325 <P>Great!! that works absolutely fine...thanks for help!!!</P> Wed, 30 Jan 2019 05:26:49 GMT https://community.splunk.com/t5/Splunk-Search/How-do-you-display-the-last-4-months-in-Splunk-starting-from-the/m-p/431197#M173325 sbhatnagar88 2019-01-30T05:26:49Z https://community.splunk.com/t5/Splunk-Search/How-do-you-display-the-last-4-months-in-Splunk-starting-from-the/m-p/431198#M173326 <P>@sbhatnagar88 If your problem is resolved, please accept an answer to help future readers.</P> Wed, 30 Jan 2019 12:32:22 GMT https://community.splunk.com/t5/Splunk-Search/How-do-you-display-the-last-4-months-in-Splunk-starting-from-the/m-p/431198#M173326 richgalloway 2019-01-30T12:32:22Z https://community.splunk.com/t5/Splunk-Search/How-do-you-display-the-last-4-months-in-Splunk-starting-from-the/m-p/431199#M173327 <P>@sbhatnagar88 , if it helped, please accept as answer</P> Sun, 03 Feb 2019 02:55:28 GMT https://community.splunk.com/t5/Splunk-Search/How-do-you-display-the-last-4-months-in-Splunk-starting-from-the/m-p/431199#M173327 renjith_nair 2019-02-03T02:55:28Z https://community.splunk.com/t5/Splunk-Search/How-do-you-display-the-last-4-months-in-Splunk-starting-from-the/m-p/431200#M173328 <P>Thanks much!! Problem has been solved...</P> Fri, 08 Feb 2019 05:49:06 GMT https://community.splunk.com/t5/Splunk-Search/How-do-you-display-the-last-4-months-in-Splunk-starting-from-the/m-p/431200#M173328 sbhatnagar88 2019-02-08T05:49:06Z