Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I 'm counting cases from open date to close date and i have to show distinct count of cases as expression and dimension as Month year.
i have to show all cases which are active between open date to close date
How to show Distinct(count of cases) cummulative between these date in bar graph across month Year (eg nov 2013)
Please post an example document. It's not clear if open date and close date are fields in your data model or if they are variables. It's not clear if you only have a month year field or also a date field. So it's not possible to give you a solution. It depends on the data available in your document.
Open date and close date are in Same fact table ,they are not variable. I will post you more info ASAP can u please help with avilaible info as if now.
That sounds like you need to create reference dates for the cases. See this blog post: Creating Reference Dates for Intervals.