I need to show average length of time spent in shop per date.
I have a variable named LOT (Length of Time) to work out the average length of time spent in shop
=[Length of Time]/[Customers]
When I place the above variable alongside Date of Shop visit I get multiple rows for the 1 date e.g.
It will show for example (just made up dates):
LOT (Length of Time) Date of Visit Customer
2 08/06/2020 1
6 08/06/2020 2
8 08/06/2020 1
How do I get the Length of Time showing as 1 figure against the Date of Visit instead of over 3 lines in table?
It should really show 1 Length of Time 3.5 against Date of Visit 08/06/2020.