Need Help for overall analysis

[pgarcia75]

Hi all

I have created a chart with an expression :

count({1<Open_Incident={">$(=MonthStart(AddMonths(now(2),-1)))"},Open_Incident={"<$(=MonthEnd(AddMonths(now(2),-1)))"},GH={GH09},Site={HTD,CCH,BRC}>}[Domaine_Incident])

I want to select a range of dates. I thought the default mode of selection was AND between conditions.

The selection of [Open_Incident] does not work. Only the second term is active.

How can I do?

thank you

[danielrozental · Accepted solution]

You need to write it like this

count({1<Open_Incident={">$(=MonthStart(AddMonths(now(2),-1)))<$(=MonthEnd(AddMonths(now(2),-1)))"},GH={GH09},Site={HTD,CCH,BRC}>}[Domaine_Incident])

[pgarcia75]

Hi

It's working

Thanks for all

P