Hello!
I'm working on a large amount of data and attempting to sort the values by year. Since there are multiple dates and times entered for 1 year, I've decided it would be simplest to group all the dates by year.
Question: When attempting to group dates by year, there is a seconds option. How do I make sure I wont miss any dates in the year?
Ex: 01/01/2010 00:00:00 and ending at 31/12/2010 24:00:00. If I set it up this way, will I be able to capture every date for the year 2010? Will the time that is entered (ex: 12/01/2010 2:29:00 AM) mess up the calculations and how can I avoid this?
Also, lets say grouping has worked. I have used "Calculated Field" Option to compare the average between years by using ( = 'totals' / 2 ) , ( ='totals' / 3) etc for the number of years Im comparing it against. So it will find the average over 2 and 3 years etc, by dividing the amounts total column by the number of years I want.
Ex: year 2010 total = 150,Year 2011 total = 100, therefore 150+100/2 = 200 average between 2010 and 2011.... calculated field = totals /2
Does this seem like the best way to do this?
Thanks!
Bookmarks