3 Replies Latest reply on Oct 7, 2013 10:40 AM by Matt Lutton

    use calculated results on another sheet?

    Weiyi Wang

      Hey guys, I have made a text table with data looks like this:

      user_id     invoice

      1001        178082

                     182293

      1002        207703

                     277991

                     589907

      1003        144472

                     250241

                     379892

       

      Then I want to count how many invoices each user generated, so I set up a calculation filed to count invoice (count(invoice)). Now the table looks like:

      user_id     invoice_count

      1001          2        

      1002          3

      1003          3

      1004          7

      1005          1

       

      Now, what I want to do is to make a bar chart to show how many of my users have 1 invoice, how many of them have 2, and 3, and so on. Probably, I have to make a new sheet and make another counting calculation filed and then make the chart. But the problem is, I have no idea about how to use (or retrieve, or fetch) the calculated results data on invoice_count column. Can anyone help here? Thank you very much!!! I just began to use Tableau two days ago...