3 Replies Latest reply on Apr 30, 2015 4:44 AM by Shawn Wallwork

    Team ratings

    Ivan Majic

      Hello everyone,

      I am working on one project where I have a problem calculating overall results for individual sport teams.

      Let me explain in detail:

      I have a table that contains match measures, and for every match I have a home and away team. The problem is that I have to calculate overall numbers for each team, meaning that weather that team is in the home or away cell, those numbers need to be added to that team. I understand that this is not a natural behavior for the table because it urges for redundancy but if anyone has any idea of some formula available in Tableau or some kind of a workaround I would be more than grateful.

       

      Thanks,

      Ivan