2 Replies Latest reply: Sep 5, 2015 10:29 PM by arjun rao RSS

    Advanced expressions for text fields issue

      Hi guys,

       

      I want to get a certain value in a text object, a day.

       

      In a certain pie chart I show which day is the busiest day in hours, my expresion and dimension looks like:

       

       

       

      DIMENSION

       

      =if(match(TaskPerfMonth,'Jan','Feb','Mar', 'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'), TaskPerfWeekDay)

       

       

      EXPRESION:

       

      Sum({<operator={'AAA'}>} aggr(Sum(total_hours),Registration,TaskPerfDay,TaskPerfMonth)

       

      / if(GetSelectedCount(TaskPerfMonth)=0,12,GetSelectedCount(TaskPerfMonth)))

       

       

      Now the pie charts shows me per the average amount of hours per week day within that year:

       

      test.png

       

      Now I want to show the Day with the highest value in a text object. Is this possible, if yes how would I do that?