Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Measure on Axis

Hello

I have some student data as follows  (Blue fields are measures)...

I want to plot the students by the Pass Range, but when I pull the Passed Range measure onto a chart, it doesn’t show the groupings (just the 25-49 % Range) and I don’t get the ‘Don’t Summarize’ option.

The Pass Range measure is …

 

Pass Range = IF( [pct Passed Exams] <= 0.24,

"0-24 % Range",IF([pct Passed Exams]> 0.24 && [pct Passed Exams] <= 0.49,

"25-49 % Range",IF([pct Passed Exams]> 0.49 && [pct Passed Exams]< 0.74,

"50-74 % Range","75-100 % Range")))

 

If I pull the Student_ID, I get the correct value per student, but I can't seem count students by Passed Range 

 

Any suggestions how I fet this to work?

 

Thanks in advance

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Thanks for pointing out the article.

     

    It's not what I'm looking for, but I managed to solve the issue using Calc Cols.

     

    Regards/

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymousjust checking you are adding passed range as column in your model not measure

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thank for getting back to me

      The passes range is a measure. In the table students can have multiple exams, so I count the number of exams and the number of exams passed, so It nees to be a measure and not a Calc Col?

       

      regards/

      • parry2k's avatar
        parry2k
        Super User
        7 years ago

        Anonymous I had similar solution provided in another post, take a look and make the changes accordingly.