Rolling 12 Month Graph with hard coded field selections

[cbaqir]

I am trying to take these 2 expressions and modify it to only show the previous 12 months (where CLOSE_DATE is within the last 12 months) and need some help:

Count:

Count({$<DEFECT_ID = {"=Count({<PROCESS_STEP = {'Ticket Created (Detected)', 'Ticket Closed'}, IS_IN_PROD = {'Y'}>}PROCESS_STEP) = GetSelectedCount(PROCESS_STEP)"}, PROCESS_STEP = {'Ticket Created (Detected)', 'Ticket Closed'}, IS_IN_PROD = {'Y'}>} DISTINCT DEFECT_ID)

Avg Days:

SUM({$<DEFECT_ID *= {"=Min({$}CLOSE_DATE) >= AddMonths(Today(),-12)"},PROCESS_STEP = {'Ticket Created (Detected)', 'Ticket Closed'}, IS_IN_PROD = {'Y'}>} Aggr(  Max({$<PROCESS_STEP = {'Ticket Created (Detected)', 'Ticket Closed'},
IS_IN_PROD = {'Y'}>}PROCESS_STEP_START_DATE) - Min({$<PROCESS_STEP = {'Ticket Created (Detected)', 'Ticket Closed'},
IS_IN_PROD = {'Y'}>} PROCESS_STEP_START_DATE), DEFECT_ID)) /
(Count({$<DEFECT_ID *= {"=Min({$}CLOSE_DATE) >= AddMonths(Today(),-12)"},PROCESS_STEP = {'Ticket Created (Detected)', 'Ticket Closed'}, IS_IN_PROD = {'Y'},
DEFECT_ID = {"=Count({$<PROCESS_STEP = {'Ticket Created (Detected)', 'Ticket Closed'}, IS_IN_PROD = {'Y'}>} PROCESS_STEP) = GetSelectedCount(PROCESS_STEP)"}>} DISTINCT DEFECT_ID))

The numbers in the bottom graphs should match the numbers in the top graphs:

Message was edited by: Cassandra Baqir

[sunny_talwar]

Checking

[sunny_talwar]

See if this works... Not 100% sure if it gives you what you want or not

[cbaqir]

Thanks, looking now! Why use CLOSE_DATE and MONTH_1?

[cbaqir]

Any idea why September shows 177 on top but 172 on the bottom?

[sunny_talwar · Accepted solution]

They match now

[cbaqir]

You are my new best friend!

[sunny_talwar]

I know that