Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have created 5 Text objects with Top Categories (1,2,3,4,5) by hard coded Categories with below expression
=Num(Count({<ProblemDateType={'Opened'},Problem.dv_u_problem_category= {'Application availability'},Problem.Calendar.Year= {'2018'}>}Problem.number)/Count({<ProblemDateType= {'Opened'},Problem.Calendar.Year= {'2018'}>} Total Problem.number),'#,##0.##%')
but i am trying to get change Category name dynamically after its value get changed. plz refer below
Can any one suggest the solution.
Thanks
Rajesh
May be this
=Num(
Count({<ProblemDateType = {'Opened'}, Problem.dv_u_problem_category = {"$(=FirstSortedValue({<ProblemDateType = {'Opened'}, Problem.Calendar.Year = {'2018'}>} Problem.dv_u_problem_category, -Aggr(Count({<ProblemDateType = {'Opened'}, Problem.Calendar.Year = {'2018'}>} Problem.number), Problem.dv_u_problem_category)))"}, Problem.Calendar.Year = {'2018'}>}Problem.number)/
Count({<ProblemDateType= {'Opened'},Problem.Calendar.Year= {'2018'}>} Total Problem.number)
,'#,##0.##%')
May be this
=Num(
Count({<ProblemDateType = {'Opened'}, Problem.dv_u_problem_category = {"$(=FirstSortedValue({<ProblemDateType = {'Opened'}, Problem.Calendar.Year = {'2018'}>} Problem.dv_u_problem_category, -Aggr(Count({<ProblemDateType = {'Opened'}, Problem.Calendar.Year = {'2018'}>} Problem.number), Problem.dv_u_problem_category)))"}, Problem.Calendar.Year = {'2018'}>}Problem.number)/
Count({<ProblemDateType= {'Opened'},Problem.Calendar.Year= {'2018'}>} Total Problem.number)
,'#,##0.##%')
Hi Sunny,
Thank you for reply its seems fine but how can i get the Category names will change dynamically
and i need to show Top 2,3 ,4 & 5 in respect individual Text Objects.
Regards
Rajesh
Add the 2, 3, 4, and 5 within FirstSortedValue to get 2, 3, 4 and 5th highest category
=Num(
Count({<ProblemDateType = {'Opened'}, Problem.dv_u_problem_category = {"$(=FirstSortedValue({<ProblemDateType = {'Opened'}, Problem.Calendar.Year = {'2018'}>} Problem.dv_u_problem_category, -Aggr(Count({<ProblemDateType = {'Opened'}, Problem.Calendar.Year = {'2018'}>} Problem.number), Problem.dv_u_problem_category), 2))"}, Problem.Calendar.Year = {'2018'}>}Problem.number)/
Count({<ProblemDateType= {'Opened'},Problem.Calendar.Year= {'2018'}>} Total Problem.number)
,'#,##0.##%')
Value is working fine Sunny,
Name also should change dynamically plz refer below one
You still didn't figure out that? Really, try this
=FirstSortedValue({<ProblemDateType = {'Opened'}, Problem.Calendar.Year = {'2018'}>} Problem.dv_u_problem_category, -Aggr(Count({<ProblemDateType = {'Opened'}, Problem.Calendar.Year = {'2018'}>} Problem.number), Problem.dv_u_problem_category))
=FirstSortedValue({<ProblemDateType = {'Opened'}, Problem.Calendar.Year = {'2018'}>} Problem.dv_u_problem_category, -Aggr(Count({<ProblemDateType = {'Opened'}, Problem.Calendar.Year = {'2018'}>} Problem.number), Problem.dv_u_problem_category), 2)
I tried that but there was syntax error couldnt find.
Thank you Sunny for u r help.
-Rajesh