title: Creating Overall RAG status in Tableau
body: <p>I have three RAG status build with logic. Now my requirement is to create overall RAG over them. There are different department filters applied on three RAG status. Now I want to implement overall RAG on below condition.
  Please note - Below - G= Green, A=Amber and R=Red</p>
  
  <p>a.  G-G-G = G</p>
  
  <p>b.  G-G-A = G</p>
  
  <p>c.  G-A-A = G</p>
  
  <p>d.  A-A-A = A</p>
  
  <p>e.  G-G-R = R</p>
  
  <p>f.  G-R-R = R</p>
  
  <p>g.  R-R-R = R</p>
  
  <p>Please suggest</p>
  
  <p>Below image shows how we are working for RAG1</p>
  
  <p>[1]</p>
  
  <p><a href="https://i.stack.imgur.com/dqJYQ.jpg" rel="nofollow noreferrer">2</a></p>
  
  <p><a href="https://i.stack.imgur.com/dqJYQ.jpg" rel="nofollow noreferrer">This image shows dashboard having three RAG and above all on left is overall RAG</a></p>
  
  <p>Considering situation a.    G-G-G = G
  IF RAG1 returns G AND RAG2 returns G AND RAG3 returns G then over all RAG will be G(Green)</p>
  
  <p>Now, Considering situation d.   A-A-A = A
  IF RAG1 returns A AND RAG2 returns A AND RAG3 returns A then over all RAG will be A(Amber)</p>
  
  <p>Now, Considering situation e.   G-G-R = R
  IF RAG1 returns G AND RAG2 returns G AND RAG3 returns R then over all RAG will be R(Red)</p>