3 Replies Latest reply on Nov 11, 2018 11:01 AM by Shinichiro Murakami

    Title of the question with the lowest score

    Raoul Verhaegen

      Hi all,

      I need a little bit of help to analyse the results of a survey of blood donors on their last donation.


      So my file has 5 columns:

      1- a dimension that specifies whether the donor has answered the survey or not

      2- the score out of 10 that the donor has given (null if not answered)

      3- the venue code

      4- the donor's ID

      5- the title of the survey's question


      I have done 2 calculations :

      - the first one is the general score: it is the proportion of distinct donors that have given a score of 8 or higher to a question

          COUNTD(IF [Choice Text]>7 THEN [Donor ID] END)/COUNTD([Donor ID])


      - the second one is essentially the same, but by venue code:

      { INCLUDE [Code]: COUNTD(IF [Choice Text]>7 THEN [Donor ID] END)/COUNTD([Donor ID])}


      So there are 18 different questions that are asked for each venue, by each donor who has answered the question.


      What I need to do is figure out, for each venue, which question had the lowest score? This is going to be a nested LOD calculation and I've tried to get some inspiration from this thread, but it didn't work....


      Any help greatly appreciated