Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I probably wont explain this well but here goes....
I have a file that has a list of dates, locations and technicians. What I would like to do is show how many technicians were at a location on a certain date.
But what I would also really like to do is create a list displaying 5, 4, 3, 2, or 1 technicians on site, so that when the user clicks on a number it will display all data for a location, for example clicking on 5 then all data that had 5 technicians there, or 4 technicians and so forth on a certain date will be shown.
Thanks,
Adam
Would something like this in the load script help ?
load
Date ,
Location ,
count(Technician) as TechnicianCount
from ..............
group by Date , Location
sorted by Date , Location
;
Would something like this in the load script help ?
load
Date ,
Location ,
count(Technician) as TechnicianCount
from ..............
group by Date , Location
sorted by Date , Location
;
You can create a Count(technicians) field in you script and group by Location and Date.
Or
Not sure if this would work but create an expression list box. AGGR(Count(technician),date,location)
Hi Adam,
In the list box of date add a expression like count(technician) it will display like below:
Date
21-jul-14 4
12-jul-14 5
20-jul-14 3
Thanks to everyone on this, was staring at me all along but this has worked fantastically. Its unfortunate I can only mark one post as the correct answer as all seem to work.
Thanks and all the best!
Adam