4 Replies Latest reply: Jul 3, 2012 7:17 PM by 13rachely RSS

    Creating a Chart

      Hello,

      I am trying to make a table, where I use field values as the dimensions.

      For example I have one list box that counts a number for a specific date, and another with the words yes/no.  When either are highlited it counts the number in that specific circumstance. How do I create a table that will look like this

       

                     YES      NO

      DATE     Count     Count
      DATE     Count     Count
      DATE     Count     Count

       

       

      Sorry I didn't really know how to explain it.  Any help would be appreciated.

       

      Thanks

        • Re: Creating a Chart
          Stefan Wühl

          I am not really sure about your list box that counts the numbers, are you using an expression together with the date field in that list box?

           

          Anyway, I would try starting with a pivot table chart object, then use your date field and the Yes/No field as dimensions.

          Create one expression (the one you are using in the list box, something like count(FIELD) )

           

          Then drag the Yes/No dimension to the top (click on the dimension header and drag with the mouse while keeping mouse button pressed).

           

          Hope this helps,

          Stefan

            • Re: Creating a Chart

              Sorry I don't quite understand where and what to drag...

              I don't know if I was very clear. What I was hoping for was instead of having yes/no as the column name (with yes/no repeated over and over again throughout the column), but instead to have one column named yes, and another that has no, and just have counts beneath them.

                • Re: Creating a Chart
                  Stefan Wühl

                  So you are having a field with two possible distinct values 'yes' and 'no', right? If you use this field as dimension, you are actually getting the field values yes and no as column (if dragged to the top) headers.

                   

                  Could you maybe post some sample lines of your input data?

              • Re: Creating a Chart

                Thanks, I figured out the drag and drop