1 2 Previous Next 17 Replies Latest reply on Mar 16, 2018 8:41 AM by Buster Sammo

    What is best way to sum up number of checked columns

    Buster Sammo

      I think this is a problem that could be done many ways (like change the data format etc),

      but I wondered what the easiest way would be in Tableau -  ie bringing the data into Tableau, just as it is, and then changing as needed once inside Tableau.

       

      I thought this should be pretty easy, but it was not easy for me. But then I am only just learning Tableau.

       

      Input data:

       

      Assume you have a  table looks like this. You have a bunch of zip codes, and each month has an X

      if you did some action that month . (At this point, don't care what the action is - assume something like found a geocache box)

      An X for a given month means a box was found in that zipcode.

       

       

      zipcodeaprmayjunjuloctnov
      60004
      60025xxxxxx
      60048
      60062xxxxx
      60193
      60631x
      60007
      60010
      60010
      60015x
      60016
      60022
      60029

       

       

      Output desired:

       

      The problem I want to visualize is to show a count  for each zipcode, or how many months in a given zipcode have a checkbox.

      And perhaps I don't want to show it as a map -- just want to show it as a table or a chart. As a table it would look like this:

       

       

      zipcodetotal
      60004
      600256
      60048
      600625
      60193
      606311
      60007
      60010
      60010
      600151
      60016
      60022

      60029

       

       

       

      or even this:

       

       

      zipcodeaprmayjunjuloctnovtotal
      60004
      60025xxxxxx6
      60048
      60062xxxxx5
      60193
      60631x1
      60007
      60010
      60010
      60015x1
      60016
      60022
      60029

       

       

      Thanks for any help :-)

        1 2 Previous Next