Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There,
Could you help me with the following?
I have a chart, with a date (settlement date) as dimension. and as expression the number of cases settled by that date (for example Jan 2016). The dimension is a group created with years, months, weeks.
I need to show all the number of cases that settled by Jan '16 / all cases that were closed in Jan '16
My problem is that all cases closed means all cases closed even the ones not settled (with date of settlement null to understand)
I have
Count (TOTAL {<CloseYear={$(=only(SettleYear)}, SettleYear>} DISTINCT CASE_ID)
but works only when I select the SettleYear, while I need to have it for each year .
I'm testing in a table with SettlYear as dimension and that as expression.
Refer this document
Refer this document