3 Replies Latest reply on Jul 1, 2016 3:38 AM by Yuriy Fal

    adjust Y-axis to be based on a calculated field(dimension)

    Michael Jensen

      Hi everyone


      I'm currently trying to make a graph with months on the x-axis, and probability of default in percentage on the y-axis.


      However, I want the y-axis to show the underlying rating instead of the probability percentage, so I make the calculated field:


      if [PD] > 0 and [PD] <=0.000080 then 'A1-1'

      ELSEIF [PD] > 0.000080 and [PD]<=0.000120 then 'A2-1'

      ELSEIF ... and so on..


      Is there any way to have the Y-axis showing the underlying ratings as given above instead of the PD-%?


      Thanks in advance