8 Replies Latest reply on Sep 28, 2018 8:15 AM by venkatram

    How to show summary table data based on conditional field filters?

    Lawrence Alatrash

      Hi all,

      So below I've added two tables of sample data, one showing the raw data, the other showing the viz I am trying to create in Tableau.  I think a few examples for the columns would be enough for me to apply the same logic to add the rest of the columns, but besides the "PERSON" dimension as a row, and "Number of Measures" as a column, I'm not quite sure how to add other totals that filter conditionally, if that makes sense?  Sorry if this is a big ask, I assume even 1 example of how to conditionally filter would be a big step forward in terms of recreating the rest.  Any help is appreciated, thank you!

       

         

      DIFFICULTYCORRECTNESSPERSON
      EASYCORRECTA
      EASYCORRECTB
      HARDINCORRECTA
      HARDCORRECTA
      EASYINCORRECTA
      HARDINCORRECTC
      HARDINCORRECTD
      EASYCORRECTB
      EASYCORRECTA
      EASYINCORRECTA
      HARDINCORRECTB
      HARDCORRECTC
      HARDCORRECTC
      HARDINCORRECTD
      EASYCORRECTA
      EASYCORRECTA
      EASYINCORRECTB
      HARDINCORRECTD
      HARDINCORRECTA
      EASYCORRECTA
      EASYCORRECTD
      EASYINCORRECTD
      HARDCORRECTA
      HARDINCORRECTD
      HARDINCORRECTD
      EASYCORRECTB
      EASYCORRECTC
      EASYINCORRECTD

                

      TOTAL TASKSTOTAL EASY TASKS% EASY TASKS% EASY CORRECTAVG % EASY CORRECTTOTAL HARD TASKS% HARD TASKS% HARD CORRECTAVG % HARD CORRECTAVG % CORRECT TOTAL
      A11764%71%36%436%50%29%64%
      B5480%75%36%120%0%29%60%
      C4125%100%36%375%67%29%75%
      D8338%33%36%563%0%29%13%