Get Selected Count

Mon, 19 Dec 2016 20:23:10 GMT

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.

topic Get Selected Count in App Development

Get Selected Count