I think you will need to instead compare against WINDOW_AVG([Click_Rate)]
and WINDOW_AVG([Open_Rate)], and then you will need to set the
Table Calculation Settings appropriate for your view.
Alternatively, you can use a Level of Detail calculation to get the averages:
Been working on this problem so long.. Really frustrated.
see the attached
I had to use superstore data because you didn't include your twbx workbook
so you will need to adapt it to your problem
convert your rates to lods similar to this
determine the overall avges like this
I used a color code to create 4 blocks (I used 1,2,3,4 you would use your terminology'
it plots like this
Drop the overall calculations on the reference line under analytics using avg
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
4 quadrants.twbx 2.4 MB