3 Replies Latest reply on Apr 21, 2018 11:34 AM by Diogo Braga

    Special LODs (figuring out how many parents applied to more than one school and more)

    Diogo Braga

      The goal is to create a visual showing the count of parents that applied to more than one schools, and how many parents for each school.

      I figured out the first part, but I am struggling on the second.

       

       

      2018-04-19_1007.png

       

      So far I was able to calculate the count of parents that applied to more than one school with this calculations:

       

       

      {FIXED [Academic Year],[Parent ID Modified]: IF COUNT([Parent ID Modified])>=2 THEN '1' ELSE '0' END}

       

      {FIXED [Academic Year],[School Code],[Grade]: COUNTD(IF [Calculation1]='1' then [App ID Modified] end) }

       

      In this example, parent ID 966825 applied to CRE, SCA, WIN.

       

       

      2018-04-19_1006.png