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 ...
Show and Tell
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