my requirement is first i need to create the month field.above date it is available 3 months and each month having multiple date because time stamp.so i need to create only one date instead of 3 dates.like below
JUN-2018 like that,how to achieve this.
I am writing the exp in script level for month field like
date(floor(date(mydate,'DD/MM/YYYY hh:mm:ss'),'MMM-YYYY') as month
after derive the month field i want to create the line chart with rolling 12 months.if i have 4 months how to write the expression.