How to generate a Month-Year Series with 3 months interval ?

[promukh]

Hello Experts,

I need to generate a series of values in the form of Year-Month to part of the drop down list in the Panel

I was trying the below but it only generates the data for 1 Month 

|makeresults  | eval month = strftime(relative_time(now(), "+3mon@mon"), "%B %Y")  | return $month

Jan 2021

Expected Ouput :

Jan 2021

April 2021

JULY 2021

[richgalloway]

Try this

| makeresults 
| eval month = strftime(relative_time(now(),"@mon"), "%B %Y"), month2 = strftime(relative_time(now(),"-1mon@mon"), "%B %Y"), month3 = strftime(relative_time(now(),"-2mon@mon"), "%B %Y") 
| eval month=mvappend(month3,month2,month)
| mvexpand month
| fields + month | fields - _time