Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
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])
Hi
It's working
Thanks for all
P