Forum Discussion
Solved
Trend Visualization compared to previous week
Hi, I try to visualize a change in a number (a sum of trucks per week) compared to the previous calender week. For example...in Calendar Week 15 I counted 380 and in Calendar week 16 I counte...
The myMax variable is essentially grabbing the current weeknum in the context of your visual. So, myMax - 1 essentially dials this back a week. So, if your current week is 16, when you are filtering for last week you want the rows where WeekNum is 15.
Thanks! I somehow managed to get the data right.
THX!
Don't worry.
I just realised how to work it out by myself.