Conditional statement in Chart expression !!!!

[#1]

Hi,

I am trying to show the values in the column chart based on a conditional statement. But the expression is not working. Can anyone please help?

Below is the expression that i am using.

Sum({<Date={">=$(DynamicMonthTrend6)"}*{"<=$(=Date(Max(Date)))"}, Quarter=,  [Question]={'Completion Rate'}>}

if([Total Responses]<=30,0,[Total Responses]))

Date={">=$(DynamicMonthTrend6)"}*{"<=$(=Date(Max(Date)))"}: This is defining the time period i.e. months across which columns would be computed i.e "Total Responses".

I want to show sum of "Total Responses" when is >30 else 0 should be shown for that month.

[alexandros17]

the problem is surely related to this part of expression:

Date={">=$(DynamicMonthTrend6)"}*{"<=$(=Date(Max(Date)))"}

if you need a range just do:

Date={">=$(DynamicMonthTrend6)<=$(=Date(Max(Date)))"}

[#3]

This is also not working.

=Sum({<Date={">=$(DynamicMonthTrend6)<=$(=Date(Max(Date)))"}, Quarter=,  [Question]={'Completion Rate'}>}

if([Total Responses]<=30,0,[Total Responses]))

If i remove the conditional statement and define it as below then it is working fine.

=Sum({<Date={">=$(DynamicMonthTrend6)<=$(=Date(Max(Date)))"}, Quarter=,  [Question]={'Completion Rate'}>}

[Total Responses])

Am i defining the conditional statement correctly?

[#4]

The problem is that values across all the months are getting changed to 0. Instead i want to change the value only for those month for which it is <=30.

[alexandros17]

can you post your documetn?

[#6]

Got it resolved. Actually the data was <30 and also Zero suppressed option was enabled.

Thanks.