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
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