Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.