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!