!!! Need Help - Generate Utilization report of specific lab resources !!!

[Anonymous]

Dear Friends,

I have set of data for a specific lab resources utilization in excel format and need to generate a report from it .Kindly refer the data which i have preapred manually for a sample with 10 columns whereas in original data it may be more than 100 columns. 

Kindly help me and suggest the right viusalization type as well instead of bar chart if the RSR cloumn has increased.

	RSR1	RSR2	RSR3	RSR4	RSR5	RSR6	RSR7	RSR8	RSR9	RSR10	MONTHLY RSR UTILIZATION (AVG.)
JAN-21	45%	56%	78%	65%	18%	28%	42%	59%	35%	49%	48%
FEB-21	98%	79%	105%	94%	0%	0%	97%	0%	100%	72%	65%
MAR-21	100%	0%	100%	100%	0%	0%	82%	0%	0%	100%	48%
APR-21	0%	0%	95%	100%	83%	88%	85%	98%	0%	92%	64%
MAY-21	0%	0%	0%	0%	100%	33%	62%	36%	0%	100%	33%
Yearly Average Utilization	49%	27%	76%	72%	40%	30%	74%	39%	27%	83%
Total RSRL Utilization	51%	51%

[v-kkf-msft]

Hi @Anonymous ,

Does your problem have been solved? If it is solved, please mark a reply which is helpful to you.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

[Anonymous]

Team,

I have checked and this solution worked for me..

Thanks for your support..

[lbendlin · Accepted solution]

First step is to bring your core data (the data points that are original, not derived)  into a usable format, usually by unpivoting.  "More than 100 columns"  is an early warning sign of bad process design.

Go from this:

to this:

and then use measures to calculate the rest.