topic Re: Week to week difference using autocalendar in App Development

Week to week difference using autocalendar

Martin-DWH — Thu, 11 Jul 2024 12:29:56 GMT

Hello everyone,

I want to calculate the Week-to-Week difference in Sales. My app uses the autocalendar, so I am able to see the week and the year, but I don´t know how to calculate the difference between current week and past week.

I´ve enclosed the script if you need reference.

Thanks for your help!

Re: Week to week difference using autocalendar

anat — Thu, 11 Jul 2024 12:45:27 GMT

Can you try by calculating week number then apply[ week number minus previous( week number)

Re: Week to week difference using autocalendar

LucQod — Thu, 11 Jul 2024 12:53:47 GMT

U can use autocalendar field WeeksAgo :

Example :
Count({<[ReloadEnd.autoCalendar.WeeksAgo]={0}>}distinct [ReloadEnd])

Count({<[ReloadEnd.autoCalendar.WeeksAgo]={1}>}distinct [ReloadEnd])

ofc if u want calculate the difference between current week and past week.

Re: Week to week difference using autocalendar

marcus_sommer — Fri, 12 Jul 2024 11:57:12 GMT

Take a look to interrecord-functions like above() to reference to calculations within any cell of your chart. Within a simple chart like yours it might be:

sum(Value) - above(sum(Value))

Re: Week to week difference using autocalendar

Martin-DWH — Mon, 15 Jul 2024 12:33:18 GMT

The above() function did the trick! Thanks!