Forum Discussion
Finding counts for Last Week
Hi everyone, I have a table similar to the below in which data comes in multiple times in a week. The count for a particular Vertical/Domain/Team combination is taken as the count for the latest ...
Hi,
Can you just clarify who you get your desired result for Vehicle/Car/*?
Also, how is "last 1 week" more rigorously defined?
Regards
Last 1 week would be the default Sunday through Saturday.
For Vehicle/Car/* it would be a summation of cars of all types sold in the current week starting Sunday
17-10=7 for tesla, 20 for Ford and 0 for Toyota giving a total of 27**
**The post said 12 which was a calculation error from my side. Apologies. I've corrected it