Need LY Comparisons for Second KPI's

[Jay587]

Hi Team,

I have created few KPI's for the sales based on time periods but somehow I unable to populate the comparison for last year data in second KPI's.

Could you please help me on expressions for the second KPI's for the below KPI's for last year 30 days ,last year MTD...etc

 Rollling 30 days = sum( {< date = {">=$(=date(Today()-29))<=$(=Today())"} >} sales)

Month so far = sum({<date={">=$(=monthstart(Today()))<$(=Today())"}>}sales)

Week so far = =sum( {< date = {">=$(=Weekstart(Today()))<=$(=Today())"} >} sales )

Yesterday = Sum({<date={">=$(=date(today()-1))"}>} sales)

[brunobertels]

Hi 

try this 

for example : 

Rollling 30 days LY = sum( {< date = {">=$(=date(addyears(Today(),-1)-29))<=$(=addyears(Today(),-1))"} >} sales)

[Jay587]

Hi @brunobertels 

Can you please let me know how to derive the Week so far (PY WTD) and Yesterday for PY ?

Thanks in advance.

[Kushal_Chawda]

@Jay587  try below

PY WTD = sum( {< date = {">=$(=weekstart(addyears(Today(),-1)))<=$(=addyears(Today(),-1))"} >} sales)

Yesterday PY = sum( {< date = {">=$(=addyears(Today(),-1)-1)<=$(=addyears(Today(),-1))"} >} sales)

[Jay587]

HI @Kushal_Chawda ,

Many thanks for your quick help.

Could you please also help me on below KPI's for PY comparison?

• 12 months Rolling for PY
• PY YTD

Thanks.

[Kushal_Chawda · Accepted solution]

@Jay587  try below

12 months rolling PY = sum( {< date = {">=$(=monthstart(addmonths(addyears(Today(),-1),-11)))<=$(=addyears(Today(),-1))"} >} sales)

PY YTD = sum( {< date = {">=$(=yearstart(addyears(Today(),-1)))<=$(=addyears(Today(),-1))"} >} sales)