2 Replies Latest reply on Sep 10, 2018 11:31 AM by manoj kumar

    Actual vs Target vs Variance

    manoj kumar

      Hi Everyone,

       

      Good Day! I wanted to create an actual vs target bar chart with a variance based on each hour. If my target for each hour is not met, I wanted to show my variance and my new overall target.

       

      My target for the day is 1000 and i need to check my target for each hour. If my target for the hour is not reached, then i wanted to show the variance and show the new target for each hour.

       

      Could you please suggest how to calculate it?

       

      Thank you in advance.

       

      BookingTime(hr)

      TotalTicketCount

      2018-09-05 00:59:59

      50

      2018-09-05 01:59:59

      34

      2018-09-05 02:59:59

      23

      2018-09-05 03:59:59

      23

      2018-09-05 04:59:59

      54

      2018-09-05 05:59:59

      54

      2018-09-05 06:59:59

      234

      2018-09-05 07:59:59

      56

      2018-09-05 08:59:59

      234

       

      Cheers

      Manoj

        • 1. Re: Actual vs Target vs Variance
          Deepak Rai

          You may attach a  packaged workbook to show what you were doing and where you got stuck to get help faster.

          Thanks

          Deepak

          • 2. Re: Actual vs Target vs Variance
            manoj kumar

            Hi deepak,

             

            Thank you for getting back to me. It is my organization's data and also i'm not very sure how to share that. But let me show you a glips of what i'm trying to, i have a target of 12000 tickets to be achieved in 2 days. I have set an hourly target to reach my target with-in two days. My hourly target is 250 for the coming two days. If the hourly target is not met, i wanted to show the variance in the bar chart and also show the adjusted target for the rest of the hours.

             

             

            Date

            TicketCount

            9/9/2018 12:59:59 AM

            100

            9/9/2018 1:59:59 AM

            200

            9/9/2018 2:59:59 AM

            300

            9/9/2018 3:59:59 AM

            400

            9/9/2018 4:59:59 AM

            100

            9/9/2018 5:59:59 AM

            200

            9/9/2018 6:59:59 AM

            100

            9/9/2018 7:59:59 AM

            200

            9/9/2018 8:59:59 AM

            300

            9/9/2018 9:59:59 AM

            300

            9/9/2018 10:59:59 AM

            300

            9/9/2018 11:59:59 AM

            300

            9/9/2018 12:59:59 PM

            300

            9/9/2018 1:59:59 PM

            300

            9/9/2018 2:59:59 PM

            300

            9/9/2018 3:59:59 PM

            300

            9/9/2018 4:59:59 PM

            300

            9/9/2018 5:59:59 PM

            300

            9/9/2018 6:59:59 PM

            300

            9/9/2018 7:59:59 PM

            300

            9/9/2018 8:59:59 PM

            300

            9/9/2018 9:59:59 PM

            300

            9/9/2018 10:59:59 PM

            300

            9/9/2018 11:59:59 PM

            300

            9/10/2018 12:59:59 AM

            100

            9/10/2018 1:59:59 AM

            121

            9/10/2018 2:59:59 AM

            110

            9/10/2018 3:59:59 AM

            32

            9/10/2018 4:59:59 AM

            234

            9/10/2018 5:59:59 AM

            234

            9/10/2018 6:59:59 AM

            543

            9/10/2018 7:59:59 AM

            200

            9/10/2018 8:59:59 AM

            300

            9/10/2018 9:59:59 AM

             

            9/10/2018 10:59:59 AM

             

            9/10/2018 11:59:59 AM

             

            9/10/2018 12:59:59 PM

             

            9/10/2018 1:59:59 PM

             

            9/10/2018 2:59:59 PM

             

            9/10/2018 3:59:59 PM

             

            9/10/2018 4:59:59 PM

             

            9/10/2018 5:59:59 PM

             

            9/10/2018 6:59:59 PM

             

            9/10/2018 7:59:59 PM

             

            9/10/2018 8:59:59 PM

             

            9/10/2018 9:59:59 PM

             

            9/10/2018 10:59:59 PM

             

            9/10/2018 11:59:59 PM