6 Replies Latest reply on Nov 25, 2018 8:54 PM by Shinichiro Murakami

    about inventory calculation

    Frank Fu

      Hi every one, I am pretty new to Tableau,  tried for a while, pretty impressive what it can do.  However there is a problem I can not solve and need help.

       

      I have a list of item, and the date into storage and the date out storage, I would like to have a list of the inventory ( number of items in storage) refer to date.

      I can not count entry base on entry date,  count off on off date, then calculate the difference. I only can do with one date. 

      Is there some function can help? or any solution? Thanks so much

      Capture.JPG

        • 1. Re: about inventory calculation
          Shinichiro Murakami

          Please attach sample data and illustrate expected result with using the number in the sample data as example.

           

          Shin

          • 2. Re: about inventory calculation
            Frank Fu

            sample would like this:  same production with different serial number,  only need to count how many production in  storage at any date.

             

             

            IDEntry DateDate Out
            A0012016-10-022016-10-22
            A0022016-10-032016-10-23
            A0032016-10-042016-10-24
            A0042016-10-052016-10-25
            A0052016-10-062016-10-26
            A0062016-10-072016-10-27
            A0072016-10-082016-10-28
            A0082016-10-092016-10-29
            A0092016-10-102016-10-30
            A0102016-10-112016-10-31
            A0112016-10-122016-11-01
            A0122016-10-132016-11-02
            A0132016-10-142016-11-03
            A0142016-10-152016-11-04
            A0152016-10-162016-11-05
            A0162016-10-172016-11-06
            A0172016-10-182016-11-07
            A0182016-10-192016-11-08
            A0192016-10-202016-11-09
            A0202016-10-212016-11-10
            A0212016-10-222016-11-11
            A0222016-10-232016-11-12
            A0232016-10-242016-11-13
            A0242016-10-252016-11-14
            A0252016-10-262016-11-15
            A0262016-10-272016-11-16
            A0272016-10-282016-11-17
            A0282016-10-292016-11-18
            A0292016-10-302016-11-19
            A0302016-10-312016-11-20
            A0312016-11-012016-11-21
            A0322016-11-022016-11-22
            A0332016-11-032016-11-23

             

             

            desired result like this,

                

            dateTotal InTotal Outinventory
            2016-10-0211
            2016-10-0322
            2016-10-0433
            2016-10-0544
            2016-10-0655
            2016-10-0766
            2016-10-0877
            2016-10-0988
            2016-10-1099
            2016-10-111010
            2016-10-121111
            2016-10-131212
            2016-10-141313
            2016-10-151414
            2016-10-161515
            2016-10-171616
            2016-10-181717
            2016-10-191818
            2016-10-201919
            2016-10-212020
            2016-10-2221120
            2016-10-2322220
            2016-10-2423320
            2016-10-2524420
            2016-10-2625520
            2016-10-2726620
            2016-10-2827720
            2016-10-2928820
            2016-10-3029920
            2016-10-31301020
            2016-11-01311120
            2016-11-02321220
            2016-11-03331320
            2016-11-04331419
            2016-11-05331518
            2016-11-06331617
            2016-11-07331716
            2016-11-08331815
            2016-11-09331914
            2016-11-10332013
            2016-11-11332112
            2016-11-12332211
            2016-11-13332310
            2016-11-1433249
            2016-11-1533258
            2016-11-1633267
            2016-11-1733276
            2016-11-1833285
            2016-11-1933294
            2016-11-2033303
            2016-11-2133312
            2016-11-2233321
            2016-11-2333330
            2016-11-24
            2016-11-25
            2016-11-26
            2016-11-27

             

             

            Many Thanks!

            • 3. Re: about inventory calculation
              Frank Fu

              Thanks, I posted a sample.

              • 4. Re: about inventory calculation
                Shinichiro Murakami

                From edit data source, pivot data.

                 

                Result

                 

                 

                 

                 

                For all three calc fields, table calc needs to be set as above.

                 

                Thanks,

                Shin

                • 5. Re: about inventory calculation
                  Frank Fu

                  Thank you so much!

                  • 6. Re: about inventory calculation
                    Shinichiro Murakami

                    HI Frank,

                     

                    You are welcome.

                    As a forum manner, please mark my answer as correct / helped not from inbox but from original post.

                     

                    Thanks,

                    Shin