Need a little more to go on, unfortunately... sample workbook possible?
I'm not quite sure, as my dataset has confidential information (names,etc.) that I can't extract.
I have a list of medical patients with a start and end date. There is a calculated variable to show how many are active at a given point in time, which is calculated by:
if ((isnull([ENROLLMENT_END_DT]) or [ENROLLMENT_END_DT]>=[$Calculation: Current Time Start Dimension]) and
[ENROLLMENT_START_DT]<=[$Calculation: Current Time End Dimension]) THEN "Show" ELSE "Hide" END
I currently have parameters set up for current, last week, last month, and last year for the number of active clients. However, I would like to be able to show a time series of how many clients are active across a year, month, etc.
Thanks for your help.