I would like to show in a single visual the value for each day and also the average of the whole period. (the aggregation is hour)

I was expecting that the averaged values would have been the same throught the whole report but it seem that it is not…

I would like to show all the values per day and then also the averaged vauels for the day of the week for example.
so one line will be the full data, while every monday there will be the same value for all the mondays…I hope I explained myself

Lets say this is the data set:
the average of the mondays is 15+12 =13.5 and so on for all the days.
If I use this calculated parameter avg(value) and then I plot this against the day of the week it works…

But If I plot with the date, it will show always the same values of the day…

I would like to have the avg value for each day of the week calculated using all the days in the dataset and then show this repeated pattern over imposed to the trend date vs value…