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 
Hi @remba87 , can you please provide some sample data and the desired output based on the sample data in table format?
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…
hoe it is clearer now
Hello at the end I solved at the source of the data…
I caclulated the field I wanted and then join the values in the table.
thank you
Wonderful! Thank you for sharing your solution with the community, @remba87.