Skip to Content
0
Jun 15, 2020 at 08:43 AM

Average amount per Date (On single row in table)

63 Views

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.