10 Replies Latest reply: Oct 9, 2015 7:21 AM by Chris Weldon RSS

    Heatmap - set analysis date question

    Chris Weldon


      I am trying to use a heatmap to show scores in different dimensions.

       

      I am using an extension to have buttons set a variable to determine which line of business and which date to use (I don't want it affected by other selections).  It seems to work for the Line of Business, but not for date.  I currently get the most recent data whatever the date selection is.  Any ideas?

       

      The expression I am using is:

      Sum({1<[LoB]={$(=vBrokerSurveyLoB)},[Date]={'=$(=vBrokerSurveyDate)'}>}[Score])

       

      New to set analysis - so I suspect it is a syntax issue.  It seems if I make the = for the Date into a <= it works okay and sums up the scores, but that is not what I want!

       

      Many thanks in anticipation.

       

      Chris