Dynamically Changes the value in Text Object

[Rajesh]

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

[sunny_talwar · Accepted solution]

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.##%')

[Rajesh]

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

[sunny_talwar]

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.##%')

[Rajesh]

Value is working fine Sunny,

Name also should change dynamically plz refer below one

[sunny_talwar]

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)

[Rajesh]

I tried that but there was syntax error couldnt find.

Thank you Sunny for u r help.

-Rajesh