2 Replies Latest reply: Aug 21, 2017 3:14 AM by Andrea Gigliotti RSS

    Not working as expected when I use normal count and set analysis count in if condition

    sam pusala

      Using below logic.

      By default it should calculate last Quarter for all the years which looks fine for me, but when I select Year and Quarter Q1 I am getting Jan, Feb, Mar, Apr, May, Jun as below image instead Jan, Feb, Mar. Here I am using pivot chart with time drill Year-->Quarter.

       

      if(GetSelectedCount(Year)>=1 or GetSelectedCount(Quarter)>=1, 

      count(TimeSpent),

      count({<Quarter={$(vLastQuarter)}>}TimeSpent))

       

      It looks it is simple but I feel I am missing something.

      For my testing count(TimeSpent) is working as expected, issue is when try to show defaults for last Quarter with the above logic.

       

      appreciate for your help.

       

      Not Ok if I select current Quarter:

      img1.PNG

      Ok if I select last Quarter  with the above if condition or simple count(TimeSpent).

      img2.PNG