How to have 2 expressions in one?

[Anonymous]

Hi,

I hope you are doing great.

I have two questions:

1. I have 1 expression but I need to add an additional condition inside the expression? I need to count all the closure codes that are equals to Escalation Request and just display it from past 6 months, I need to mix these 2 expressions in one:

Count({$<[Closure Code] = {'Escalation Request'}>} DISTINCT CustomID)

=Count({$<CustomID = {"=Date#(YRMON, 'YYYY-MM') > MonthStart(Today(), -7)"}>} CustomID)  

2. How can I remove the current month on the above expression? I need that November information is not displayed (YRMON is the field used).

Any ideas?

[settu_periasamy]

Maybe try this..

=Count({$<[Closure Code] = {'Escalation Request'},
YRMON={">=$(=MonthStart(Today(), -7))<=$(=MonthEnd(Today(), -1))"}={>} DISTINCT CustomID)

[Anonymous]

I got an Allocated Memory Exceeded message on the chart.

[Anonymous]

The second expression is causing the message.

[sunny_talwar · Accepted solution]

May be this:

Count({$<CustomID = {"=Date#(YRMON, 'YYYY-MM') > MonthStart(Today(), -7) and Date#(YRMON, 'YYYY-MM') < MonthStart(Today()) and [Closure Code] = 'Escalation Request' "}>} CustomID)