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,

[#2]

Yo can do:

if(count(values) < 20, 0, count(values)

and check supress zero values in the presentation tab

[Anonymous]

Thanks Federico for your help.

It worked, but I'd like to remove or hide Aug 2011. if it possible?

Thank you again,

[Anonymous]

It is possible by repalcing dimension field in your chart with calculated dimension.  Simple example (it may be more complex in your situation):

aggr(if(sum(Amount)>20, Month),Month)

You can make it more flexible replacing 20 with a variable, so you can use it in an input box, set default to 20, and be able to change to any number.

[Anonymous · Accepted solution]

I found out issue:)

if(aggr( count([Overall Experience Scores]) ,  MYear) > 30 , aggr( Avg([Overall Experience Scores]) , MYear) , null())

Thanks everybody for your help,

[#6]

Maybe you should add some fields in your script for a better managment of the calendar.

I use this one

LET varMinDate = Num('01/04/2010');

LET varMaxDate = num(today());

LET vToday = num(today());

//*************** Temporary Calendar ***************

TempCalendar:

LOAD

          $(varMinDate) + rowno() - 1 AS Num,

          date($(varMinDate) + rowno() - 1) AS TempDate

AUTOGENERATE

          $(varMaxDate) - $(varMinDate) + 1;

//*************** Master Calendar ***************

MasterCalendar:

LOAD                    TempDate AS submitDateTime,

                    Week(TempDate) AS Week,

                    Year(TempDate) AS Year,

                    Month(TempDate) AS Month,

                    Day(TempDate) AS Day,

                    Weekday(TempDate) AS WeekDay,

                    'Q' & ceil(month(TempDate) / 3) AS Quarter,

                    Date(monthstart(TempDate), 'MMM-YYYY') AS

                              MonthYear,

                    Week(TempDate)&'-'&Year(TempDate) AS WeekYear,

                    inyeartodate(TempDate, $(vToday), 0) * -1 AS

                              CurYTDFlag,

                    inyeartodate(TempDate, $(vToday), -1) * -1 AS

                              LastYTDFlag

RESIDENT TempCalendar

ORDER BY TempDate ASC;

DROP TABLE TempCalendar;

After you got the calendar, you could use month as dimension in your chart, and a set analysis with MonthYear to eliminate any monthyear you want.

[Anonymous]

What's wrong in this expression:

if(aggr( count(Membership) ,  MYear) > 60 , (aggr( Count(Membership) , MYear)/

  if(aggr( count(Membership) ,  MYear) > 60 , aggr( Count(TOTAL Membership) , MYear))) , null())

It works:

Count(Membership)/

Count(TOTAL <MYear> Membership)

I want to apply condition to show months where more than 60 people.

Thanks,

[Anonymous]

Probably this:

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

[Anonymous]

Thanks Michael,

The second part works, but the first not.

My Membership has Member, Not Member and etc.

So I tryed

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

It shows all months.

[#10]

You are using TOTAL for each month, remove total from the validation.