Forum Discussion

unnijoy's avatar
unnijoy
Post Prodigy
8 years ago
Solved

Category wise %

I have traing completion %. Based on that we have given catogery for each trainer. The catogery are AB&C. Some times for a month one trainer may come under A 2 times B 1 time and C 4 Times. I need a measure that will give me Catogery %. That i can put in a graph. And i can get a output like for the Month of March what is the % of A catogery, B catogery and C catogery.

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

     

    So all you need to do is add a column chart then put the category as the axis, the month as the legend then drag the completion to the values and it will create a stacked column with the same values as the chart.

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Please post some example data and what the expected result would be.

    • unnijoy's avatar
      unnijoy
      Post Prodigy
      8 years ago
      MonthTrainerCompletionCatogery
      JanAlex85c
      JanAlex80.6c
      JanJade90b
      JanPince100a
      FebAlex100a
      FebJade86.7B
      FebJade50.6c
      FebPrince60c

       

      Out put

      CatogeryJanFeb
      A%%
      B%%
      C%%

       

      In out put we need what the the total % of Catogery of A, B & C. Means for Jan Over all A is 55%. Like This i need the out put.

      Please help

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Just put a matrix visual then use category as rows month as column and completion as the vlaue.

         

        This will give you the output you provided you can either sum or average the percentages of each month.

         

         

        Also I do not see how you get 55% for Jan A, can you please elaborate