I have a sheet with essentially 3 columns of interest and am trying to create a trend graph.
First column has a string formatted date (for a week) such as "December 25, 2017", second column has an actual date/time such as "2017-12-28 11:14:09", third column has a value such as "4234234".
My goal is to create a trend by either week or day for the average value in that week/day. The sheet has thousands of rows and both "week" and "time" can be repeated.
Any advice?
First column has a string formatted date (for a week) such as "December 25, 2017", second column has an actual date/time such as "2017-12-28 11:14:09", third column has a value such as "4234234".
My goal is to create a trend by either week or day for the average value in that week/day. The sheet has thousands of rows and both "week" and "time" can be repeated.
Any advice?
