Statistics

Discussion, Questions, Ideas and Enhancement Requests for efa2

Moderator: nick

Forumsregeln
Please create new posts in the according categories and label them with an appropriate subject.
When replying to a post, please stick to its subject, and create a new subject if you want to add a whole new aspect.

Statistics

Beitragvon MinneapolisRC » So 19. Nov 2017, 02:03

Hello Nick;

Now that I have a season of data to play with, I'm experimenting with the Statistics. What is the secret to running a report that lists how many KMs a member rowed in 'Crew 1'. I'm trying to figure out the distance and number of outings that everyone bowed. The best I've been able to do so far is to run a report using 'Logbook' filtered on people and then count the number of times their name is 'bolded'. I'm sure there is a friendlier way to do this but I can't find options for filtering by seat (Crew 1,2,3,4, etc...). Can you point me in the right direction?

Thanks,
Rob
MinneapolisRC
 
Beiträge: 16
Registriert: Mo 6. Mär 2017, 20:11

Re: Statistics

Beitragvon nick » Mo 20. Nov 2017, 05:54

Hi Rob,

Hmm, you're the first one asking for this. No, this is indeed not supported at the moment. There's no way to filter by a particular seat. Your approach is the best I can think of (at least in the current version). Instead of counting bold entries by hand, you could create the logbook statistic as a CSV file (select "CSV" as output), then open the created file in a spreadsheet (Excel and co), and let Excel do the counting.

Is this a feasible solution, or do you need to do this for dozens of persons?

Thanks,
Nick
nick
 
Beiträge: 1278
Registriert: Sa 10. Jul 2010, 11:45

Re: Statistics

Beitragvon iww-martin » Fr 24. Nov 2017, 19:29

Hi Rob,

your request is possibly be a bit misleading...

Are you looking for ...

...the total distance and number of trips per person on seat 1, seat 2, seat N...?
This can actuallly only be done on exported data as Nick proposed.
or
...the total distance and the number of trips per person, no matter on which seat?
This is possible with the available report features in efa. It gives you for a chosen period the person's name, the total distance, the number of trips and the average distance per trip.

However you can distinguish between the total distance as a rower and the total distance as a coxswain.

Martin

Itzehoer Wasser-Wanderer e.V.
iww-martin
 
Beiträge: 243
Registriert: Fr 24. Feb 2012, 15:42
Wohnort: Itzehoe

Re: Statistics

Beitragvon MinneapolisRC » Sa 3. Mär 2018, 21:46

Hello Martin and Nick;

Sorry for the late response but I've been away from rowing for awhile here in the frozen North :) What I'm after specifically is a way to report the distance rowed for each individual club member in seat 1. Not really worried about seats 2 - 8. This is so that I can create a report so that each individual can see how many KMs they've bowed in blind boats. This is important to us because this number helps us update our bow list and rower qualifications for specific equipment.

and yes, I have to do this for everyone in the club (about 200) and I do eventually want to make this a report that individuals can pull themselves.

Thanks again,
Rob
MinneapolisRC
 
Beiträge: 16
Registriert: Mo 6. Mär 2017, 20:11

Re: Statistics

Beitragvon iww-martin » Do 8. Mär 2018, 16:06

Hi Rob,

ok, than you have to create a statistic to export log book entries into a csv- or xml-file. You can load the exported files in Excel.

For a csv export you have to split up in Excel the crew data column into separate seat / crew member columns.
The first crew member is the rower on seat 1.

The easisest way to see the km for rowers on seat 1 is to create a Pivot Table Report for the imported log book entry data.

I hope that helps
Martin

Itzehoer Wasser-Wanderer e.V.
iww-martin
 
Beiträge: 243
Registriert: Fr 24. Feb 2012, 15:42
Wohnort: Itzehoe


Zurück zu efa2 - Discussion / Questions / Enhancement Ideas

Wer ist online?

Mitglieder in diesem Forum: 0 Mitglieder und 1 Gast

cron