Dear,
I'm working on dashboard and I'm try to set the alerts for issue before due date or not started date & I'm write the query is
(Received Date >=5d OR Target end >= 30d will take red color as alert
Received Date >=3d AND Received Date <=4d OR Target end >=16d AND Target end <=29d will take Yellow color as alert
Received Date >=1d And Received Date <=2 OR Target end >=1 AND Target <=16d will take Green color)
to be aware I have the Received date & target end & all of them in one query is above I need advice how to solve this.
in addition, if the issue not started & take red color then started the status will green color in one column how to change the color status automated without repeated colors in the same column
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.