2 Replies Latest reply on Feb 1, 2013 6:45 AM by Daniel Ortiz

    Help Desk Ticket Reporting with variance

    Daniel Ortiz

      Hi Everyone,


      I am a newbie to Tableau and have been tasked with creating reports for the Help Desk.


      I have created several Worksheets and have modified the Fiscal Year for my company. However, I need to show the variance between the Previous FY and the Current FY.


      See the attached image of what I have created thus far.


      Thank you,

      DannyVillage Problems.jpg

        • 1. Re: Help Desk Ticket Reporting with variance
          Tracy Rodgers

          Hi Danny,


          One way you can do this would be to create a calculated field similar to the following:


          Window_VAR(sum([Number of Records]), first(), first()+1)


          Once it is placed on the view, right click and select Compute Using-->[Date Field]


          Hope this helps!



          1 of 1 people found this helpful
          • 2. Re: Help Desk Ticket Reporting with variance
            Daniel Ortiz

            Hi Tracy,


            Thank you for replying to my post. I have tried what you suggested but am not sure exactly how to place the calculated field on my view.


            Just to make sure that I am explaining this correctly, I am looking to have a 3rd column to show the difference between FY2011 and FY2102.

            For example:


            FY2011    FY2012    Variance

            55                53             -2

            27                58             31


            Then I would change the Variance to show a percentage.


            Please let me know if i am explaining it correctly.


            Thank you,