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:






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





      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:




      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?