Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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?
Can you share the sample app?
Hi,
Can you share the sample file to demonstrate your issue? Thank you.