Hide or remove month

[Anonymous]

Hi guys,

I have a bar chart by Months (I calculate month----- MonthName(Monthstart(submitDateTime)) as MYear).

Some months have count less than 20. How can I remove or hide these months?

Thanks in advance,

[Anonymous]

I can't remove TOTAL, because Membership has tags. If I remove TOTAL, it'll use only tags which have more than 60 answers.

Thanks,

[#3]

But if you use TOTAL for the validation, you will have the same result for all validations!

[Anonymous]

I use only these months where TOTAL count answers more than 60.

For example:

In Nov 2011:

Membership: gr1-15: gr-2- 35; gr-3-40;gr-4-70. TOTAL=150

In Dec 2011:

Membership: gr1-6: gr-2- 10; gr-3-10;gr-4-5.  TOTAL=31

In Jan 2012:

Membership: gr1-25: gr-2- 45; gr-3-100;gr-4-70. TOTAL=240.

In chart I should show only Nov and Jan.

Thanks,

[#5]

Can you uplaoad a sample qvw?

[Anonymous]

Please find attached file.

I want to remove Months where TOTAL count  less than 60.

Thanks,

[#7]

Like this?

[Anonymous]

This expression works, but where answers for each tags more than  60.

if(Count(Membership)>60, Count(Membership)/Count(TOTAL <MYear> Membership), null())

but where I have tags which have less than 60 answers (but TOTAL COUNT more than 60), the expression doesn't show them.

Other words, for example, in November Membership has tag1-70, tag2-150, tag3-200, tag4-45. (TOTAL=465)

Tag4 won't be show, because it's less than 60.

That's why I want to use TOTAL count. I need to show only these months where TOTAL count less than 60.

Thanks,

[#9]

But that info is in the qvw?

I can only see the fields qID_5395_Aware of Bes Price Guarantee  and  Brand that are non-date related fields.

[Anonymous]

Thanks, It works!!!!

if(Count(TOTAL <MYear> [Membership])>60,Count([Membership])/

Count(TOTAL <MYear> [Membership]), null())

Thanks you really help me!!! I needed to use it Count(TOTAL <MYear> [Membership])