Forum Discussion

SINGHTX9's avatar
SINGHTX9
Icon for Helper II rankHelper II
7 years ago
Solved

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 an...
Need Help
  • Arentir's avatar
    Arentir
    7 years ago

    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

     

Arentir's avatar
Arentir
Icon for Resolver III rankResolver III
7 years ago

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

 

  • SINGHTX9's avatar
    SINGHTX9
    Icon for Helper II rankHelper II
    7 years ago

    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.

    • SINGHTX9's avatar
      SINGHTX9
      Icon for Helper II rankHelper II
      7 years ago

      • Arentir's avatar
        Arentir
        Icon for Resolver III rankResolver III
        7 years ago

        Hey SINGHTX9

         

        Software is ScreenToGif, pretty handy for presentation indeed :)

        I will try to have a look at your question later. Some thoughts for now:

        You can have the priority added to your Final Table and Specimen distribution. Also better have a dimension table for Priority that would relate to all of the tables having priority field.