Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart that by default looks to a rolling 13 month time frame,but can be updated if the user selects a different date frame from a filter pane.
The code in the chart looks like the following:
if(GetSelectedCount(SurgeryMonthYear)>0,
count({<ORCaseVolumeFlag={1}>} LOG_ID)
,count({<SurgeryDate={"$(= '>=' & FirstDayMonthRolling12 & '<=' & LastDayMonthRolling12)"},ORCaseVolumeFlag={1}>} LOG_ID))
On a different sheet with different logic, I need the date to be updated based off a date filter as well. When I select a date outside of the rolling 13 months, no data is present.
This is the logic I have in the sheet not working as I'd like it to.
Count({<
Holiday={'N'},
Weekend={'N'},
FirstCaseInRange={'Y'},
LocationName={'DCH OR'},
AddOnCase={'N'},
ScheduledTime={"<=08:30:00 AM"},
SurgeryDate={"$(= '>=' & FirstDayMonthRolling12 & '<=' & LastDayMonthRolling12)"},
LateStartYN={'N'}
>}
Distinct LOG_ID)
/
Count({<
Holiday={'N'},
Weekend={'N'},
FirstCaseInRange={'Y'},
LocationName={'DCH OR'},
AddOnCase={'N'},
ScheduledTime={"<=08:30:00 AM"},
SurgeryDate={"$(= '>=' & FirstDayMonthRolling12 & '<=' & LastDayMonthRolling12)"}
>}
Distinct LOG_ID)
I know I need to add the GetSelectedCount somewhere in this expression, but every time I add it how I believe it should be, my data goes away.
Hoping someone can help me figure out how to make this work. Thanks in advance.