you can pull any chart with desired time interval and the days upto which u need and can do analysis on it. Also u can pull that data into excel using link to excel function. Once you are on desired script with desired interval, click on chart on menu bar and then click on export chart to excel. This will pull the time wise data in to excel which u can use for analysis.