topic Re: Need LY Comparisons for Second KPI's in App Development

Need LY Comparisons for Second KPI's

Jay587 — Fri, 15 Nov 2024 20:52:06 GMT

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)

Re: Need LY Comparisons for Second KPI's

brunobertels — Fri, 20 Sep 2024 12:36:00 GMT

try this

for example :

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

Re: Need LY Comparisons for Second KPI's

Jay587 — Mon, 23 Sep 2024 10:17:08 GMT

Hi @brunobertels

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

Thanks in advance.

Re: Need LY Comparisons for Second KPI's

Kushal_Chawda — Mon, 23 Sep 2024 10:34:40 GMT

@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)

Re: Need LY Comparisons for Second KPI's

Jay587 — Mon, 23 Sep 2024 10:43:56 GMT

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.

Re: Need LY Comparisons for Second KPI's

Kushal_Chawda — Mon, 23 Sep 2024 10:50:38 GMT

@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)