7 Replies Latest reply: Oct 17, 2013 6:11 AM by Ankita Baderiya RSS

    Bar Chart - Default selection on clear to Max(Year)

      Hi All,

      Below is the expression which I am using. But when clear button is clicked then the default data for max of year should display. how to achieve this?

       

       

      Count({<Account_Table_ACSAT.Responded={'yes', 'Yes'}, Account_Table_ACSAT.Q2_Score={6,7},Year = {$(=only(Year))},Month=,Quarter=,Day=>} Account_Table_ACSAT.Responded)
      /
      Count({<Account_Table_ACSAT.Responded={'yes', 'Yes'},Year = {$(=only(Year))},Month=,Quarter=,Day=>} Account_Table_ACSAT.Responded)

       

      Any help would be appreciated.

       

      Thanks in advance!

       

      Regards,

      Ankita