If statements with multiple conditions?

[#1]

So I'm trying to make an if statement with multiple conditions.

For example, with the excel data below, I am trying to make a Gauge Chart that counts the ID if:

Resolved Status =3 and Date Reported is 31 to 60 days before the current date today()

I would want this counted against all IDs from the 31-60 days before today() as well as all the ID's where Resolved Status<>3 regardless of date.

Basically a 3 means an issue is complete. So I want to count the completed issues from 31-60 days ago against all non-completed ID's regardless of their date.

I know that this is probably a simple matter of joining if statements; but there are so many things I need to plug in that I keep messing it up somehow.

Any help would be greatly appreciated!

[sunny_talwar]

Check if this is helpful. I made a slight change to your condition of 31 to 60 days from reporting date because there was only one date within that constraint and that too has resolved status as 1. So I changed it to be 31 to 90 days.

Have a look and let me know if this is what you wanted.

Best,

Sunny

[maxgro]

=Count({<[Resolved Status]={3},ID={"=Today()-[Date Resolved]>30"},ID={"=Today()-[Date Resolved]<90"}>}ID)