Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Plotting equipment usage by week

Hello,

am trying to plot the number of equipment we use by week. am able to plot using the start date of each equipment (see below). however some equipments are used for multiple weeks but they are only being shown in the week with the start date. is there a way i can have them shown in each week they are being used and not just on the week with start date.

 

 

appreciate your help on this

 

Regards,

 

 

Show and Tell

3 Replies

  • v-joesh-msft's avatar
    v-joesh-msft
    Icon for Solution Sage rankSolution Sage
    6 years ago

    Hi Anonymous ,

    I'm a little confused by your description. Could you share your sample data and expected result if you don't have any Confidential Information?

    Best Regards,

    Community Support Team _ Joey
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      v-joesh-msft thank you for your response. am not sure if i can send you the files but anyway, please see below the sheet

       

       

      Am trying plot for example how many set of equipment 1 i will need during the whole month. the issue am having is that i want to show where i have an overlay of 2 jobs needing the same equipment at the same time. if i plot the equipment against the job expected date this overlay is not reflected as you can see below

       

       

      Appreciate if you have any thoughts on how to address this

       

      Thanks