1 Reply Latest reply on Aug 24, 2017 7:48 AM by Shruti Jain

    How to union multiple dimensions within tableau (or Oracle SQL)?




      I have attached a sample workbook with 9 dimensions (labeled SHIFT A -> J, There is not SHIFT G). I want those dimensions to be a single column. I tried combining all the dimensions into one calculated field using an if statement, but doing that cause a conflict with shifts that contain overlapping time. For instance, if SHIFT A and SHIFT B happen to share a time my metrics would be mapped only to SHIFT A and not to SHIFT B. Thanks.