How to calculate the highest value per week period?

[wholelottared]

Hello!

I want to calculate the highest value per week on a chart. I have a data set as you can see on my screenshot. The data set 'Reading' hits high and low values every day and is separated by weeks. I would like to show the highest point (max value) of each week period or two week period. What's the best expression/chart to express this?

For example:

week 1 (04/28) the highest value of max value, 4.08

week 2 (05/12) the highest value, 4.73 and so on via a visual chart. 

Any help is greatly appreciated!

[Vegar]

What if you use YearWeek as a dimension in your chart and Max(Reading) as a measure?

If you don't have a Year Week field name you can create one in the script using the WeekName() function.