Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody
im working on a dashboard which has "YearMonth" field from the data source (month+year), i want to calculate a percentage based on the average of "sum([VISITS])" of months may-18, june-18 and july-18 and compare them with august-18.
I wanna know if there was a growth or not. How do i "separate" the months to select JUST the ones i want?
Thanks in advance
Hi, it didn't work, when I use your formula it brings me back "1" as the result. I attach you an image of the "yearmonth" list
Hi,
Try this one
((sum({<yearmonth={"=DATE(max(DATE(DATE#(yearmonth,'YYYY-MMM'))),'YYYY-MMM')"}>}VISITS) / (Sum({<yearmonth={">=DATE(max(DATE(DATE#(yearmonth,'YYYY-MMM')))-3 ,'YYYY-MMM')<DATE(max(DATE(DATE#(yearmonth,'YYYY-MMM'))),'YYYY-MMM')"}>}VISITS)/3) )-1)*100
Thank you, with little changes i could make it work!