Forum Discussion
Capacity chart analysis
Hi
I want to run capacity chart analysis for my machine. So i have two machines
Instrument A: Runs "CC" test type and has throughput of 1000 tests/hour and
Instrument B: Runs "IA" test type and has throughput of 200 tests/hour
So i have a column in my data that is receive hour which basically tell me the number of tests received in the lab on an hourly basis.
I want to make a capacity chart where user will have the ability to pick the number of instruments and i want that when the user pick "CC" test type automatically it should select Instrument A and take throughput as 1000 tests/hour and likewise for "IA" select Instrument B and take throughput 200 tests/hour
So i have managed to do it but by creating multiple measures separate for IA and separate for CC
IA calculated throughput = 200*PRODUCT('Number of Instrument Selected'[Number of Instruments Selected])
Capacity utilized = DIVIDE([Total Tests],[IA calculated throughput],0)
Can i do this in a combined way?
Link to the file:
https://1drv.ms/u/s!AlMqyIwZH-2Xa09KFmTpnfsggNs
Also i want to do scenario analysis i,e if my incoming test volume increases by 5%,10%,15% etc how would my capacity chart change?
Hi SINGHTX9,
See my solution attached, page 3
https://1drv.ms/u/s!As5oZCclkGkWgSUKbcIgvNE_f5Qd
I have created a new column [Type] in 'Selected Throughput' and created a relationship with [Test Type] in 'Actual Data' (I have noticed one row says 1200 instead of 1000 as in your post, beware of that)
I have created a what if parameter like this
The new measure is as follow:
Capacity Utilized v2 =
SUM('Actual data'[Number of Tests]) / ( SUM('Selected Throughput'[Selected Throughput]) * SELECTEDVALUE('Number of Instrument Selected'[Number of Instruments Selected]) * (1 + Parameter[Parameter Value]) )
No need for separated measures for IA/CC and you have a parameter to increase the throughput.
Hopes this helps
6 Replies
Hi SINGHTX9,
See my solution attached, page 3
https://1drv.ms/u/s!As5oZCclkGkWgSUKbcIgvNE_f5Qd
I have created a new column [Type] in 'Selected Throughput' and created a relationship with [Test Type] in 'Actual Data' (I have noticed one row says 1200 instead of 1000 as in your post, beware of that)
I have created a what if parameter like this
The new measure is as follow:
Capacity Utilized v2 =
SUM('Actual data'[Number of Tests]) / ( SUM('Selected Throughput'[Selected Throughput]) * SELECTEDVALUE('Number of Instrument Selected'[Number of Instruments Selected]) * (1 + Parameter[Parameter Value]) )
No need for separated measures for IA/CC and you have a parameter to increase the throughput.
Hopes this helps
Thanks a lot for your help Arentir. This was exactly what i was looking for
Can i ask you for another favor? In my file there is another pie chart (Attach pic below), I want to filter it also by priority but since the table for which i created this pie chart is a calculated table based on the actual data i m not able to create a realtionship between
the calculated table and my actual data table.
(In this particular data set the accession id has both Routine and STAT but ideally each accession id should either be routine or STAT).
Also when you made this video to show me how you generated the what-if parameter, did you use any special software to do it? I m actually looking to create a animated video for work purposes so was just curious.
