Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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))
hi,
what is the error in expression?
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))
still error