4 Replies Latest reply: Oct 22, 2014 5:06 PM by Niklas Hedborg RSS

    Displaying second largest value

      hi

       

      i have a chart which contains incident categories . i need to create norther 5 charts which shows d top 5 categories one by one. d largest i can get it done. but how can i display ONLY the second largest value ???

       

      my equation to calculate the count of categories as follows :

       

      count(if(year(today())=fp_year) and cat_tier='Fail',IncID))

       

      if some one could help me in this issue i would really appreciate it

       

      thank you in advance