Hi Dear Tableau community,
I have 3 sheets, with right join, it became a big soup of duplicated issues. What I'm trying to calculate are:
1. Sum total estimation, but since each issue is unique, they only needs to be counted once, if I do normal sum, it gave me 143 instead of 48
2. For each individual person, sum the estimation with filter of team and component, but sam as above, since the issue is unique, it needs to be calculated only once as well,
I just can't figure out a way make sure they are calculated only once...Is this achievable in tableau with current data structure(my real case is like this just with more tables and more joins) ? Could you pls help? sample tableau file attached.
Thanks a lot!
