I'm trying to calculate the average datapoints for the same minute in the same day of the week. For example compare the total from 00:01:00 on Monday 17th September to 00:01:00 on Monday 24th September but exclude all other days of the week. I'm currently using an LOD below which brings me to comparing the 01 Minute across all hours of all Monday's but i cannot make it specifically look at 00:01:00
[Datetime (Days)],[Datetime (Hours)]
Can anyone help?
Any chance you could provide some sample data?