Hi, thank you for your answer @Sai_Satish .
I’d like to compare each day to the previous week’s similar days of the week(Monday to the last x Mondays, Friday to the last X Fridays…etc). Let’s say I have multiple users each one has a number of transactions per day during the last 10 weeks period. Then, I want to compare this Monday transactions_count to the prior 10 Mondays data by averaging the number of transaction-during the whole past 10 Mondays(I used std_dev and mean too to detect outliers).
Now, if I understood you correctly, I have to compare my actual Monday data to the mean(hourly)data of the prior Mondays.!
Do you mind if you clarify a little bit?