10 Replies Latest reply: Jun 27, 2018 12:14 PM by Sunny Talwar

Help with syntax on line chart to only show scores over 4 AND groups that have a count over 30?

So I have successfully had a line chart where I filtered out all scores that were under 4...and successfully had a pivot chart where I filtered out groups under 30. I am trying to have a line chart where I do both...but I must be screwing things up here, because it is just making the lines disappear even though I know these groups are over 30.

So I am just using the term "Measure" for what I am having counted as being over 4 and "Filter" for what I am using in my filter pane to select what shows up in the line chart.

Num(Count({<Measure = {">=4"}, Filter = {">=30"} >} Measure) /Count({<Filter= {">=30"} >} Measure),'0%')

Thanks for any help anyone can give me!

Jordan

• Re: Help with syntax on line chart to only show scores over 4 AND groups that have a count over 30?

Are you saying that this works for you (without filter in set analysis)?

Count({<Measure = {">=4"}>} Measure)

• Re: Help with syntax on line chart to only show scores over 4 AND groups that have a count over 30?

Hi Sunny,

Sorry for the confusion.

When i have filtered out responses that just have a score above 4 the syntax I used was this:

Num(Count({<Measure = {">=4"}>} Measure) /Count(Measure),'0%')

• Re: Help with syntax on line chart to only show scores over 4 AND groups that have a count over 30?

And this worked without any issue?

• Re: Help with syntax on line chart to only show scores over 4 AND groups that have a count over 30?

Yes, that showed me the responses that were only equal to or above 4 on the line chart.

I am having difficulty with having responses shown that are equal to or above 4 AND I would like to only show groups that have a count of equal to or above 30 based on a filter pane.

• Re: Help with syntax on line chart to only show scores over 4 AND groups that have a count over 30?

Perhaps I should be adding the equal to or above 30 logic/syntax to the filter pane and not the line chart?

• Re: Help with syntax on line chart to only show scores over 4 AND groups that have a count over 30?

count of equal

What do you mean by count of equal? Would you be able to support you discussion with some sample data and expected output?

• Re: Help with syntax on line chart to only show scores over 4 AND groups that have a count over 30?

The Filter group is a department list. So say Department 1 has 51 listings, Department 2 has 25 listings, Department 3 has 61 listings and so on.

If I were to select Department 2 in the filter, I would want it to not show up in the line chart because the count is under 30. But if I were to select Department 1 or Department 3, I would want it to show up in the line chart because the count is over 30.

Does this make sense?

• Re: Help with syntax on line chart to only show scores over 4 AND groups that have a count over 30?

May be this

Num(Count({<Measure = {">=4"}, Department = {"=Count(Listing) >= 30"}>} Measure) /Count({<Department = {"=Count(Listing) >= 30"}>} Measure),'0%')

• Re: Help with syntax on line chart to only show scores over 4 AND groups that have a count over 30?

Running into the same problem with it not showing up on the line chart.

• Re: Help with syntax on line chart to only show scores over 4 AND groups that have a count over 30?

Would you be able to provide a sample or sample data to test this?