4 Replies Latest reply on Jul 30, 2018 7:09 AM by Paula Sims

    Adding and Classifying Data while double counting

    Paula Sims

      I need to create an output using the client's connection to a database and custom SQL for the calcs. Here's what the resulting table looks like and the desired results. The client wants the results in the Tableau style format. I tried duplicating it using titles but not good enough for the client. The only way I could figure out how to do this is to add a column (in SQL) that shows a split count and then And then do a Tableau calc that says: If the Overall = Late or Split then Count Late. If the Overall is Split or OnTime then Count on-time. Basically I have to count each instance separately. What would that calc look like? Any other ideas or how to do this? Any other ideas?

       

      Thanks

       

       

      Also in Tableau Public as https://public.tableau.com/profile/paula.sims#!/vizhome/ClassificationsExamples/Dashboard1?publish=yes