3 Replies Latest reply: Aug 5, 2010 11:07 PM by shanrahan RSS

    Object Conditional Show

      In the conditional show option for a chart, how do I only show the chart of the sheet has at least three fields selected? There is too much data to load the chart without multiple selections.

        • Object Conditional Show
          Neil Miller

          The GetSelectedCount function will tell you how many items are selected in a certain field.

          GetSelectedCount(FIELD) > 0

          If you have multiple fields, then you can combine them:

          GetSelectedCount(FIELD1) + GetSelectedCount(FIELD2) + GetSelectedCount(FIELD3) >= 3

          You could also put this as a Calculation Condition. If the Calculation Condition is not met, the chart outline will display, but there will be an error message and no data. The error message can even be customized. This may work better as you won't have a big blank space in your app.

          • Object Conditional Show
            John Witherspoon

            Not sure how to do exactly what you're asking for other than exhaustively checking every possible field, but what about counting how well their filters have narrowed down the data set? Something like count(MainID)<100000. It'll still take a little time to do the count, but probably nothing like the chart, assuming you have a complex chart.

            • Object Conditional Show

              I'm going to put NMiller's answer as my suggested answer because that is what I was going for. However, John's answer is a great idea and I'm actually going to implement that one in my program. Thank you both!