2 Replies Latest reply: Dec 5, 2011 4:28 AM by Sam Vile RSS

    Set Analysis syntax

      I swear this is possible but I can't quite get the syntax

       

      I have the following set analysis that shows me data for all our active history FTE where the ExtractDate is the same as the UploadDate:

       

      sum({<Measure={'ActiveHistory'},ExtractDate={'$(=max({<KPI={'FTE'}>} UploadDate))'}>} FTE)

       

      What I need to do is add the following to it:

       

      Count({<Measure={'Vacancies'},ExtractDate={'$(=max({<KPI={'Vacancies'}>} UploadDate))'}>} Measure)

       

      The reason is because at the moment these two are separate expressions, I only want the one.

       

      Is this possible?

       

      Any help is appreciated.

        • Re: Set Analysis syntax

          Hi Sam,

           

          First things first. Your set analysis is wrong in both expressions.

           

          Use the following.

           

           

          sum({<Measure={'ActiveHistory'},ExtractDate={"$(=max({<KPI={'FTE'}>} UploadDate))"}>} FTE)
          


          and

          Count({<Measure={'Vacancies'},ExtractDate={"$(=max({<KPI={'Vacancies'}>} UploadDate))"}>} Measure)
          


          Secondly, how do you want to use the sexond expression? Do you want to integrate the second expression in the set analysis part of the first expression?

           

          Do clarify,

           

          BR,

          Abhi