Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I'm working on an app with the following structure :
Table:
Date --- SerialNumber ---- Site
01/01/2019 serial1 Paris
01/01/2019 serial2 Paris
01/01/2019 serial3 London
08/01/2019 serial1 Paris
08/01/2019 serial2 Paris
08/01/2019 serial3 London
15/01/2019 serial1 Paris
15/01/2019 serial2 London
15/01/2019 serial3 London
What I want to do is to calculate, for each date I have, for each site, the count of serial number (ie. distinct device) that entered or left. It can be either in script or graph calculation directly in the app, I can change both.
In the example I gave above, it would mean :
In the real table, I have over 100 sites and 300.000 serial number per day.
I've been trying to figure this out for a couple of days and I can't think of anything, help would be gladly appreciated.
Thank you !
Anyone ? 😞