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

    Displaying second largest value



      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