I am facing a issue on below condintions. can any one help on this. My Requirement is i want to display count of ids by using below conditions. I have Weekendsaturday column, if user selects MonthYear='201902' . it should display count of ids per weeks for that entire month.But we need to display based on few conditions. i.e. if user selects Feb month, for each week it should calculate ids based on open,closed, and backlogs conditions.
Open means- Ticket Generated Date.
Closed means- Ticket Closed Date
Backlog Means-Unresolved Tickets. Based on these dates i want to write a condition in line chart expression.
a)Weekendsaturday='2019-02-02' 1)Open=(begin_date>='2019-01-27' and <='2019-02-02') 2)Closed=(Close_date>='2019-01-27' and <='2019-02-02') 3)backlog=(begin_date<='2019-02-02') and (Close_date>'2019-02-02' or (Close_date is null)) b)Weekendsaturday='2019-02-09' 1)Open=(begin_date>='2019-02-03' and <='2019-02-09') 2)Closed=(Close_date>='2019-02-03' and <='2019-02-09') 3)backlog=(begin_date<='2019-02-09') and (Close_date>'2019-02-09' or (Close_date is null)) c)Weekendsaturday='2019-02-16' 1)Open=(begin_date>='2019-02-10' and <='2019-02-16') 2)Closed=(Close_date>='2019-02-10' and <='2019-02-16') 3)backlog=(begin_date<='2019-02-16') and (Close_date>'2019-02-16' or (Close_date is null))
Can any one please give me idea how to approach this one. Thanks in Advance.
