S
shahnaz
I have a database with 14,000 records (trips) showing time duration for
journey to work (JTW).
Range of times is from 1-298 minutes. I need to first group the time
durations and then I need a show those time durantions as a percentage of
Grand total of records(trips). For example using a smaller group - If I have
24 records and 8 records show a time duration of 22 minutes, 6 records show
12 minutes, 4 records show 10 minutes and 6 records show 5 minutes. That
would mean that approximately 33% of records show a JTW time duration of 22
minutes, 25% show JTW of 12 minutes, 15% show 10 minutes and another 25% show
5 minutes.
Please advise.
Thanks
journey to work (JTW).
Range of times is from 1-298 minutes. I need to first group the time
durations and then I need a show those time durantions as a percentage of
Grand total of records(trips). For example using a smaller group - If I have
24 records and 8 records show a time duration of 22 minutes, 6 records show
12 minutes, 4 records show 10 minutes and 6 records show 5 minutes. That
would mean that approximately 33% of records show a JTW time duration of 22
minutes, 25% show JTW of 12 minutes, 15% show 10 minutes and another 25% show
5 minutes.
Please advise.
Thanks