How do I filter to only display results when the count is >5?

[#1]

I have a survey results report.  How do I filter the report to only display results when the number of responses, per survey question, is >5?  In the example below, I would only want to show the results for Q1 and Q2, since Q3 total responses are <5.

For example:

     Question      # Responses

        1                   10

        2                    5

        3                    4

[swuehl]

If Question is the dimension and # Responses the expression in a straight table chart, you could use for example (there are mulitple ways to do this) dimension limits:

Open the chart properties, go to dimension limits tab.

Select Question dimension and enable limits checkbox with options 'Show only values that are' 'greater than' '5' 'exact amount'

Disable 'Show Others' checkbox if not needed.

[#3]

Thank you for the quick response! I am not seeing a limits checkbox. Here is my display:

The “Confidence Level” dimension is my “Question”

[padmanabhan_ram · Accepted solution]

please find the attached solution.

Br,

Padmanabhan

[jagan]

Hi,

Try like this

Chart:

Dimension: Question

Expression: If(Sum(Responses) > 5, Sum(Responses))

[#6]

That works for one dimension.  How to I modify this if I have two dimensions, for example:

Question

    Location 1    10

    Location 2    3

I want the report to display Location 1 and value 10, but not display Location 2.