limiting too many lines in line chart

[#1]

I have a chart that uses cycle group. The group consists of partner, region, and country. On the page where the chart is, there are list boxes for region, country, partner, and some others. Typically, the user has not yet selected any of the countries in the list box. When the user is viewing the chart by region, everything is fine - there are three lines representing the region that we have. However, when the user cycles to the country, then it shows all of the countries (lot of them), and all the lines representing the country looks like a rubber ball. If the chart has only one dimension(country) then I can control the calculation condition to not to show the lines when there are more than x number of countries. However, I can't apply this condition when the dimension is part of a cycle group. Any ideas on how to do this? Thank you in advance for any suggestions.

[#2 · Accepted solution]

Use...

=

GetCurrentField(Sales)

Will work, the Sales above is the name of the group. Put it in a text box and you will see the name change for the dim of the group as you cycle through it.

[#3]

Thanks That did the trick. What I ended up is something like this:

code

= if(GetCurrentField("Partner_Group_Region") = 'Country', GetSelectedCount(Country) <>0 and GetSelectedCount(Country) <= 10,

if(GetCurrentField("Partner_Group_Region") = 'Partner Name', GetSelectedCount([Partner Hierarchy]) <>0 and GetSelectedCount([Partner Hierarchy]) <= 10,

null()))

/code

This is what I ended up for the Calculation Condition box. This checks for two of the dimensions in the Cycle group where the check is necessary.