Bar chart

[#1]

i have so many employee names in bar chart but i want to show 10 prescribed names,please give me a expression and where to write

[#2]

10 prescribed names means top 10 or above 10 or below 10 or first 10 or last 10

please explain breifly

[#3]

Hi Narotham,

If your values depends on the limits(top 10, small, greater or so) then you can go to dimension limits and set the values or else you may create a variable and assign the values to that variables which can be used in your expressions.

Thanks,

Sai

[#4]

Hi Narotham,

If u want show employees based on metric you can use dimension limit show only largest 10.

In other case you can sort the dimensions(descending) based on metric ,go to presentation tab Enable X-axis scrollbar and give 10 as when number of items exceeds.in this case you can show all values in sorting order.

Regards,

Vijay

[rustyfishbones]

Hi,

try using a Calculated Dimension using IF and MATCH, I have added 4 names but you can add 10 by just adding a ,'next name'

IF(MATCH(EmployeeName,'John','George','Paul','Ringo'),EmployeeName)

[rustyfishbones]

you can add the Calculated Dimension here

[#7]

Hi,

You can also write set analysis with your employee list.

=sum({<Employee={ 'John','George','Paul','Ringo'}>}Sales)

regards,

Vijay

[jagan]

Hi,

If you want to show the 10 prescribed members only then try like this

=Sum({MemberDimensionName = {'Member1', 'Member2', ............'Member10'}>} MeasureName)

If the members list keeps on changing then put it in an excel file and load into dashboard and use below expression

=Sum({<NewMemberDimensionName ={'*'}>} MeasureName)

Hope this helps you.

Regards,

Jagan.