Logic Help...

[abhaysingh]

hi all,

i have to show site name, the site which is best...

i bar chart i tool dimension Site and count(SiteId) as Measure..

i want the best site and worst site name to display in text box..

How i can do this?

[Kushal_Chawda]

For worst site  below expression in Text object

=Firstsortedvalue(Site, aggr(Count(SiteID), Site) &':' & Firstsortedvalue(sum(aggr(Count(SiteID), Site)), aggr(Count(SiteID),Site))

For Best site  below expression in Text object

=Firstsortedvalue(Site, -aggr(Count(SiteID), Site) &':' & Firstsortedvalue(sum(aggr(Count(SiteID), Site)), -aggr(Count(SiteID),Site))

[abhaysingh]

hi,

what is the error in expression?

[Kushal_Chawda]

one bracket is missing. Try this

=Firstsortedvalue(Site, aggr(Count(SiteID), Site)) &':' & Firstsortedvalue(sum(aggr(Count(SiteID), Site)), aggr(Count(SiteID),Site))

For Best site  below expression in Text object

=Firstsortedvalue(Site, -aggr(Count(SiteID), Site)) &':' & Firstsortedvalue(sum(aggr(Count(SiteID), Site)), -aggr(Count(SiteID),Site))

[abhaysingh]

still error