Forum Discussion

Kurumi0418's avatar
Kurumi0418
Helper I
8 years ago

I Have one important question.

  Hello everyone,   How to use value = table, question as blow :   Value: Overall Turn rate history = DIVIDE( SUM('WAITING_TIME_REPORT_HISTORY'[Rule Output]), SUM('WAITING_TIME_REPORT_HISTOR...
Need Help
quentin_vigne's avatar
quentin_vigne
Solution Sage
8 years ago

Hi Kurumi0418

 

What result are you expecting ? Show us what the column C should look like (with value)

You need a percentage ? 

 

- Quentin

  • Kurumi0418's avatar
    Kurumi0418
    Helper I
    8 years ago

    Hi Quentin,

     

    I want "C_Table" = overall turn rate values, it doesn't percetage.

     

    Thanks.

     

    Because, I want use "C" to X bar, but now I just have overall turn rate value, and it doesn't same with "C"

     

    Overall turn rate is right valure = Rule output/WIP

     

    See the picture. thanks Quentin.

     

    • quentin_vigne's avatar
      quentin_vigne
      Solution Sage
      8 years ago

      Kurumi0418

       

      I'm note to understand what you want but did you try this : 

       

      CALCULATE(DIVIDE(sum('WAITING_TIME_REPORT_HISTORY'[Rule Output]),sum('WAITING_TIME_REPORT_HISTORY'[WIP]));ALL(WAITING_TIME_REPORT))

      If this doesn't work can you tell me the values expected of C_Table ? (Is C-Table the yellow line on the picture ? )

       

      - Quentin

      • Kurumi0418's avatar
        Kurumi0418
        Helper I
        8 years ago

        Hi Quentin,

         

        I want use measure value in Chart X bar like "1.3", But now I use Column calculate [Rule output/WIP] it's different "Overall turn rate" value, so how can I make right valure?????