How to sort by rolling month (Community)

View the original community article here

Last tested: Oct 4, 2019
 

To sort their data by current month for ex: October 2019 thru November 2018, you can throw this in the lookml (dialect specific may be required):
 

dimension: this_month_num {

   hidden: yes

  sql: MONTH(CURDATE());;

 }    

dimension: sort_relative_month {

   type: number

   sql: CASE

         WHEN (${this_month_num} - ${created_date.month_num}) = 0

         THEN 12

         WHEN (${this_month_num} - ${created_date.month_num}) < 0

         THEN 12 - -1*(${this_month_num} - ${created_date.month_num})

         ELSE ${this_month_num} - ${created_date.month_num}

         END;;

 }