Forum Discussion

Pinky0404's avatar
Pinky0404
Helper III
8 years ago

Trend for Grading

Hi All,

 

I am trying to show a trend  for the grades. i have a column "Grade" which has grade values say A,B,C etc based on the rating score.

 

Eg:  Grade= if (rating<400,"F",if(rating>400  && if(rating <700,"D"),"C"). 

 

The below trend shows the grade values along with rating, and if i use the grade column under values dimension of the chart that is showing the count but not the Grades .Is it possible to just show the grades trend, Can someone help me on this?

 

 

Thanks in Advance!!

Pinky

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Pinky0404,

     

    I don't think you can apply trend feature on text value.

    if you means analysis the trend of numeric value, you can turn on trend line to simply achieve your requirement.

     

     

    Regards,

    Xiaoxin Sheng