0 Replies Latest reply: Dec 8, 2016 2:08 PM by Amanda Bonura RSS

    Get Selected Count and Additional Date Filters

    Amanda Bonura

      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.