Hello Emily Alden,
Could you try changing both your pills to Measure while using SUM(avg)?
That should fix your issue
Let me know if you need more details.
Lénaïc RIÉDINGER, Global Community Engineer Tableau
If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!