10 Replies Latest reply on Apr 18, 2018 9:51 PM by ranjit saha

    Need pointer on the Gantt Chart viz

    ranjit saha

      Hello,

      I am trying to recreate something that is similar to the picture that is attached.

      Basically, i have few processes that runs across the day with its own start and end time and it has its respective duration of run.

      In the chart i want to represent how much the server is utilized or available.

      would appreciate some pointers on creating it.

      twbx

       

      Sample data"

              

      WeekDayProcessStd TransactionRunStart TimeDuration in minsEnd TimeSuccessFailureWeeklyOverallSuccess %Comments
      Week12-Apr-18ST 110:000:05:0010:052096%74%100%d
      Week13-Apr-18ST 11:000:05:0011:05901 99%
      Week14-Apr-18ST 12:000:06:0012:0641 80%qdfqd
      Week15-Apr-18ST 13:000:05:0013:0551 83%qfq
      Week16-Apr-18ST 14:003:05:0017:0561 86%qff
      Week17-Apr-18ST 0:00:000 fwefw
      Week18-Apr-18ST 0:00:000
      Week29-Apr-18ST 0:00:0002463% 33%
      Week210-Apr-18ST 0:00:00031 75%
      Week211-Apr-18ST 0:00:00032 60%
      Week212-Apr-18ST 0:00:00091 90%
      Week213-Apr-18ST 0:00:00023 40%
      Week214-Apr-18ST 0:00:000
      Week215-Apr-18ST 0:00:000
      Week316-Apr-18ST 0:00:0004651% 40%
      Week317-Apr-18ST 0:00:00081 89%
      Week318-Apr-18ST 0:00:00038 27%
      Week319-Apr-18ST 0:00:00071 88%
      Week320-Apr-18ST 0:00:00038 27%
      Week321-Apr-18ST 0:00:000
      Week322-Apr-18ST 0:00:000
      Week423-Apr-18ST 0:00:0007652% 54%
        • 1. Re: Need pointer on the Gantt Chart viz
          Tushar  More

          Hi Ranjit,

           

          Check this great article.

          Using Gantt charts in Tableau to manage projects | Tableau Software

           

          ~Tushar

          If that helps, please mark the answer as correct and helpful.

          • 2. Re: Need pointer on the Gantt Chart viz
            Kawaljeet kaur

            Hi Ranjit,

             

            you can drag your calculation(which has output of number server utilized) on the size mark and inc/dec your size chart.

            further drag same calculation to label ->alignment to center to complete this view.

             

            Thanks

            Kawal

            • 3. Re: Need pointer on the Gantt Chart viz
              ranjit saha

              Tired the options.. but the chart is not coming the way we wanted it.

              Adding the twbx

              • 4. Re: Need pointer on the Gantt Chart viz
                ranjit saha

                this twbx is not uploading..

                here is the snapshot for reference:

                 

                • 5. Re: Need pointer on the Gantt Chart viz
                  Tushar  More

                  Please post sample data.

                  • 6. Re: Need pointer on the Gantt Chart viz
                    ranjit saha

                    Hello Tushar,

                    attached the sample data in the original post itself and here as well:

                    Thanks,

                    Ranjit

                    WeekDayProcessStd TransactionRunStart TimeDuration in minsEnd TimeSuccessFailureWeeklyOverallSuccess %Comments
                    Week12-Apr-18ST 110:000:05:0010:052096%74%100%d
                    Week13-Apr-18ST 11:000:05:0011:05901 99%
                    Week14-Apr-18ST 12:000:06:0012:0641 80%qdfqd
                    Week15-Apr-18ST 13:000:05:0013:0551 83%qfq
                    Week16-Apr-18ST 14:003:05:0017:0561 86%qff
                    Week17-Apr-18ST 0:00:000 fwefw
                    Week18-Apr-18ST 0:00:000
                    Week29-Apr-18ST 0:00:0002463% 33%
                    Week210-Apr-18ST 0:00:00031 75%
                    Week211-Apr-18ST 0:00:00032 60%
                    Week212-Apr-18ST 0:00:00091 90%
                    Week213-Apr-18ST 0:00:00023 40%
                    Week214-Apr-18ST 0:00:000
                    Week215-Apr-18ST 0:00:000
                    Week316-Apr-18ST 0:00:0004651% 40%
                    Week317-Apr-18ST 0:00:00081 89%
                    Week318-Apr-18ST 0:00:00038 27%
                    Week319-Apr-18ST 0:00:00071 88%
                    Week320-Apr-18ST 0:00:00038 27%
                    Week321-Apr-18ST 0:00:000
                    Week322-Apr-18ST 0:00:000
                    Week423-Apr-18ST 0:00:0007652% 54%

                     

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      

                    WeekDayProcessStd TransactionRunStart TimeDuration in minsEnd TimeSuccessFailureWeeklyOverallSuccess %Comments
                    Week12-Apr-18ST 110:000:05:0010:052096%74%100%d
                    Week13-Apr-18ST 11:000:05:0011:05901 99%
                    Week14-Apr-18ST 12:000:06:0012:0641 80%qdfqd
                    Week15-Apr-18ST 13:000:05:0013:0551 83%qfq
                    Week16-Apr-18ST 14:003:05:0017:0561 86%qff
                    Week17-Apr-18ST 0:00:000 fwefw
                    Week18-Apr-18ST 0:00:000
                    Week29-Apr-18ST 0:00:0002463% 33%
                    Week210-Apr-18ST 0:00:00031 75%
                    Week211-Apr-18ST 0:00:00032 60%
                    Week212-Apr-18ST 0:00:00091 90%
                    Week213-Apr-18ST 0:00:00023 40%
                    Week214-Apr-18ST 0:00:000
                    Week215-Apr-18ST 0:00:000
                    Week316-Apr-18ST 0:00:0004651% 40%
                    Week317-Apr-18ST 0:00:00081 89%
                    Week318-Apr-18ST 0:00:00038 27%
                    Week319-Apr-18ST 0:00:00071 88%
                    Week320-Apr-18ST 0:00:00038 27%
                    Week321-Apr-18ST 0:00:000
                    Week322-Apr-18ST 0:00:000
                    Week423-Apr-18ST 0:00:0007652% 54%
                    • 7. Re: Need pointer on the Gantt Chart viz
                      Tushar  More

                      Ranjit,

                       

                      I meant to say upload excel file.

                      • 8. Re: Need pointer on the Gantt Chart viz
                        ranjit saha

                        Hello Tushar,

                        please find the sample data and the twbx that i was preparing.

                        thanks.

                        • 9. Re: Need pointer on the Gantt Chart viz
                          Tushar  More

                          Hi Ranjit,

                           

                          Thanks for the file. For Tableau to correctly plot the, date and time fields should be put together. In your data they are separate fields. So, I combined them in the attached file. Still, it may not give you the exact gantt chart effect because of your data. However, the basics remain same.

                          • 10. Re: Need pointer on the Gantt Chart viz
                            ranjit saha

                            Hello Tushar,

                            i tired that.. but somehow its not coming correct. the duration should merge on the hour axis. maybe something fundamental we are missing. The start and end have the timestamp, the difference i guess should be hours.

                            thanks,

                            Ranjit