1 Reply Latest reply: Aug 7, 2017 8:40 PM by Sunny Talwar RSS

    Graph help

    Joshua Russin

      Hey everyone,

       

      Having some issues with this graph. I can get it filtered all the way except when I try to filter by client_CD. If anyone has any comments or help, please let me know. I'm probably overthinking this one, but just can't figure it out. I am trying to get the total of Client complaints from Jan, 2016 from Biomet in a bar graph.

       

      Graph under QI graphs.

        • Re: Graph help
          Sunny Talwar

          Just responded in your other post, but the issue is extra space after the word Biomet

           

          Count({$< Year_CD = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays)))-1)"},

          Division_of_Occurance_CD = {'Olive Branch'}, Type_CD = {'CAPA-AF', 'CAPA-CAPA', 'CAPA-COM', 'CAPA-NMR'}, Client_CD = {'Biomet '}>} Num_CD)